Horton

Re: How to create a dynamic list?

Christopher Sawtell <csawtell@xtra.co.nz>

View thread View on postgr.es
From: Christopher Sawtell <csawtell@xtra.co.nz>
To: Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2001-02-24T07:34:48Z
Lists: pgsql-general 
On Sat, 24 Feb 2001 02:56, Renaud Tthonnart wrote:
> I 'd like create a type like a dynamic list.

chris=# \d+ xxx
                        Table "xxx"
 Attribute |         Type          | Modifier | Description
-----------+-----------------------+----------+-------------
 num       | integer               | not null |
 nom       | character varying(10) |          |
 nb        | integer[]             |          |
Index: xxx_pkey                                                            
                                                           
chris=# INSERT INTO xxx  VALUES(1,'aaa','{10,20,30}');
INSERT 137225 1
chris=# select * from xxx;
 num | nom |     nb
-----+-----+------------
   1 | aaa | {10,20,30}
(1 row)                                                                    
 
     
-- 
Sincerely etc.,

 NAME       Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -->> Please refrain from using HTML or WORD attachments in e-mails to me 
<<--