When is a record NULL? - Mailing list pgsql-hackers

From David E. Wheeler
Subject When is a record NULL?
Date
Msg-id 48BDABE9-88AB-46E9-BABE-F70DDBFB98BD@kineticode.com
Whole thread Raw
Responses Re: When is a record NULL?  ("David E. Wheeler" <david@kineticode.com>)
Re: When is a record NULL?  (Jeff Davis <pgsql@j-davis.com>)
Re: When is a record NULL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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…

Best,

David

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: join regression failure on cygwin
Next
From: James Pye
Date:
Subject: WIP: plpython3