When is a record NULL?

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: When is a record NULL?
Date: 2009-07-23 22:19:36
Message-ID: 48BDABE9-88AB-46E9-BABE-F70DDBFB98BD@kineticode.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James Pye 2009-07-23 22:23:40 WIP: plpython3
Previous Message Tom Lane 2009-07-23 21:57:19 Re: join regression failure on cygwin