Appending to an array

Поиск
Список
Период
Сортировка
От Jay O'Connor
Тема Appending to an array
Дата
Msg-id 3.0.1.32.20030415073651.00832100@cybermesa.com
обсуждение исходный текст
Ответы Re: Appending to an array
Re: Appending to an array
Список pgsql-general
All,

    I've got a tablewhere one of the columns contains an array.  What I'm
trying to do is to append or insert into the array.  I know I can so
something like..
    UPDATE mytable set myarray[10] = 'some value' WHERE...

..to change a particular array element, and this be used to extend the
array if the array is not that size yet, but what I need to figure out is
how to do that when I don't know the size of the array at any given time.

Thanks

Jay


В списке pgsql-general по дате отправления:

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Are we losing momentum?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Two 'identical' DB's not acting identically