On Jul 23, 2009, at 3:19 PM, David E. Wheeler wrote:
> How can a record be neither NULL or NOT NULL?
>
> try=# select ROW(1, NULL) IS NULL;
> ?column?
> ----------
> f
> (1 row)
>
> try=# select ROW(1, NULL) IS NOT NULL;
> ?column?
> ----------
> f
> (1 row)
>
> This makes it rather hard to tell, in PL/pgSQL, when I've fetched
> the last record from a cursor…
Also:
select ROW(1, NULL) IS DISTINCT FROM ROW(2, NULL);
?column?
----------
t
As expected, but the IS NULL above is not expected (by this bunny,
anyway).
Best,
David