How to create a dynamic list?
I 'd like create a type like a dynamic list.
I've tried
CREATE TYPE liste
(
INPUT = array_in,
OUTPUT = array_out,
INTERNALLENGTH = VARIABLE,
ELEMENT = int
);
CREATE TABLE xxx
(
num int,
nom varchar(10),
nb liste,
PRIMARY KEY(num)
);
This instruction give an error :
INSERT INTO xxx
VALUES(1,'aaa',(10,20,30));
ERROR: parser: parse error at or near ")"
Could someone tell me how do I have to do?
Thanks
Renaud THONNART
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
<<--