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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
