On Jul 25, 2009, at 9:24 AM, Jeff Davis wrote:
I don't think you want the "NOT x IS NULL" part at all -- that will
evaluate to false when x = rec(NULL,NULL). I think you just want the
"x
IS DISTINCT FROM NULL" part, right? Will that work?
Nope, infinite loop when because `ROW(null, null)` and `ROW()` are
both distinct from null:
try=# select row(null, null) is distinct from null, row() is distinct
from null;
?column? | ?column?
----------+----------
t | t
(1 row)
So I still can't tell when I've exhausted a cursor.
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
