Re: When is a record NULL?

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