Array question
От | Vassili A Akimov |
---|---|
Тема | Array question |
Дата | |
Msg-id | 38F605EE.5FC3A75C@erols.com обсуждение исходный текст |
Список | 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.
В списке pgsql-sql по дате отправления: