From: | Marcin Grondecki <ojciec(at)mtl(dot)pl> |
---|---|
To: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | arrays |
Date: | 1999-11-01 22:15:23 |
Message-ID: | 381E10FB.A59E3DD1@mtl.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
i've just tried to use function, but with no success
imported data from text file into table foo:
...
adr_1 varchar(80)
adr_2 varchar(80)
adr_3 varchar(80)
...
then i've added column
adr varchar(80)[]
now i'd like to update adr with appropriate values from adr_1 etc.
no syntax was adequate to it
just smth. like:
update foo set adr={adr_1, adr_2, adr_3}
any ideas?
btw: using
update foo set adr='{adr_1, adr_2, adr_3}'
(see documentation) i've got col. adr filled with: {"adr_1", "adr_2",
"adr_3"}.
--
Marcin Grondecki
ojciec(at)mtl(dot)pl
*** I'm not a complete idiot - some parts are missing
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Grondecki | 1999-11-01 22:18:57 | table - datatype |
Previous Message | Carlos Vicente Altamirano | 1999-11-01 21:41:58 | users in Postgresql |