Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls
Date
Msg-id 10295.1263917576@sss.pgh.pa.us
Whole thread Raw
In response to Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls  (ioguix@free.fr)
Responses Re: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls  ("Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
List pgsql-hackers
Tree view 
ioguix@free.fr writes:
> I found a difference of behaviour between 8.3 and 8.4 on IS NULL with 
> multi-level arrays with NULL values.

8.3's behavior is just a bug --- try comparing the results when the
values are variables that happen to be null, rather than simple
constant nulls.  8.4 is consistent with that case, 8.3 isn't.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Git out of sync vs. CVS
Next
From: Tom Lane
Date:
Subject: Re: RADIUS authentication