Re: Re[2]: How to Alter tables with ARRAY? Help PLease

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re[2]: How to Alter tables with ARRAY? Help PLease
Дата
Msg-id 22534.991806401@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re[2]: How to Alter tables with ARRAY? Help PLease  (Igor <dbmanager@osb368.nnov.ru>)
Список pgsql-general
Igor <dbmanager@osb368.nnov.ru> writes:
> Well, i have a field OSTV which has dimention [1:9][1:6]
> when i'm trying:
>  "update mytable set ostv [10][3]=333.00"

You can't extend an array unless you specify values for all the new
entries required to fill a rectangular array value (which in practice
means only one-dimensional arrays can be extended this way).

I'd like to see the array code generalized to allow you to do that,
inserting NULLs for the missing entries.  But it'd take some work,
and so far no one's stepped up to the plate to do the work.  Would
you like to volunteer?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sequences in transaction context
Следующее
От: "jackie"
Дата:
Сообщение: Database Size