Re: [SQL] Inserting values in arrays

2005-03-15 Thread Robert . Farrugia
Richard, So the solution can be:         (i) either write a function to insert the values into the array one by one         (ii) or else upgrade to 7.4 (or 8) to use the ARRAY syntax. Thanks a lot. Regards Robert Richard Huxton 03/15/2005 09:08 AM To [EMAIL PROTECTED] cc pgsql-sq

[SQL] Inserting values in arrays

2005-03-14 Thread Robert . Farrugia
I have the following issue. Given the following tables: CREATE TABLE test ( details varchar[]); CREATE TABLE test2 ( textvalue1 varchar, textvalue2 varchar); INSERT INTO test2 VALUES ('Hello1', 'World1'); INSERT INTO test2 VALUES ('hello2', 'World2'); I would like to insert a row in test for ea