| From: | Vassili A Akimov <vassili(at)erols(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Array question |
| Date: | 2000-04-13 17:37:50 |
| Message-ID: | 38F605EE.5FC3A75C@erols.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all!
I, probably, have really simple question, but I can't go further. I
have two tables: one is empty like
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| home phone number | int4[]
| var |
and another one full like
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| first | int4
| 4|
| second | int4
| 4|
| third | int4
| 4|
I need to put all elements from second table into a first one. So each
string in
second table becomes a string in a first one, so firts colun becomes a
first
array element in first table second is second and so on. I tried several
queries
in order to do this, but failed. Can anyone help?
Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lefèvre | 2000-04-13 20:27:26 | Function xxxx() does no exist |
| Previous Message | Thomas Lockhart | 2000-04-13 16:43:01 | [Fwd: [HACKERS] Porting reports (cont'd)] |