Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group