How to create a dynamic list?
Renaud Thonnart <thonnart@amwdb.u-strasbg.fr>
From: Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2001-02-23T13:56:44Z
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