Re: strange IS NULL behaviour - Mailing list pgsql-hackers

From Tom Lane
Subject Re: strange IS NULL behaviour
Date
Msg-id 19613.1373036636@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
Responses Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
Re: strange IS NULL behaviour  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Review: UNNEST (and other functions) WITH ORDINALITY
Next
From: David Fetter
Date:
Subject: Re: Review: UNNEST (and other functions) WITH ORDINALITY