Re: Arrays in PL/pgSQL routines?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Arrays in PL/pgSQL routines?
Дата
Msg-id 22479.1135881738@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Arrays in PL/pgSQL routines?  ("Ken Winter" <ken@sunward.org>)
Список pgsql-sql
"Ken Winter" <ken@sunward.org> writes:
> That works.  (Odd that the initialization seems to be necessary to make it
> work.)  Thanks!  Yes, I'm using version 7.4.

Possibly what you're running into is that 7.4 is restrictive about what
you can do with an array that's NULL.  Until pretty recently, assigning
to an element of a NULL array left the array still NULL --- this is an
artifact of the fact that the system sees the assignment as a binary
operation with the array and the new element as inputs.
        regards, tom lane


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

Предыдущее
От: "Ken Winter"
Дата:
Сообщение: Re: Arrays in PL/pgSQL routines?
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Arrays in PL/pgSQL routines?