Re: strange IS NULL behaviour

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: strange IS NULL behaviour
Дата
Msg-id 19613.1373036636@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> On Thu, Jul  4, 2013 at 04:29:20PM -0400, Tom Lane wrote:
>> No, it isn't, or at least it's far from the only place.  If we're going
>> to change this, we would also want to change the behavior of tests on
>> RECORD values, which is something that would have to happen at runtime.

> I checked RECORD and that behaves with recursion:

Apparently you don't even understand the problem.  All of these examples
you're showing are constants.  Try something like
declare r record;...select ... into r ...if (r is null) ...
        regards, tom lane



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

Предыдущее
От: Vik Fearing
Дата:
Сообщение: Re: Review: UNNEST (and other functions) WITH ORDINALITY
Следующее
От: David Fetter
Дата:
Сообщение: Re: Review: UNNEST (and other functions) WITH ORDINALITY