Re: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ioguix(at)free(dot)fr
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls
Date: 2010-01-19 16:12:56
Message-ID: 10295.1263917576@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ioguix(at)free(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-01-19 16:38:13 Re: RADIUS authentication
Previous Message Kevin Grittner 2010-01-19 16:03:58 Re: Git out of sync vs. CVS