How to create a dynamic list?

From: Renaud Tthonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to create a dynamic list?
Date: 2001-02-23 13:56:44
Message-ID: 3A966C1C.AFF5DAB8@amwdb.u-strasbg.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wayne Ward 2001-02-23 15:14:00 install problem.
Previous Message akif noor 2001-02-23 12:28:40