arrays

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

Browse pgsql-general by date

  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