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@mtl.pl
*** I'm not a complete idiot - some parts are missing