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

Re: 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: Re: When is a record NULL?
Date: 2009-07-28 19:22:34
Message-ID: F5020398-BEE9-467F-BD10-876F43EA87CE@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Jul 27, 2009, at 5:19 PM, David E. Wheeler wrote:

> Yep, that's just what I needed, thanks. I think I'll send a patch  
> for the "Cursors" section of the PL/pgSQL documentation that  
> mentions this. Would have saved me a bunch of hassle.

So would have reading two more sentences of the docs, which state, to  
my surprise (that I missed it!), “As with `SELECT INTO`, the special  
variable <code>FOUND</code> can be checked to see whether a row was  
obtained or not.” D’oh!

So now I've got things working the way I need, and I've blogged about  
these SQL pathologies so that I don't forget.

   http://www.justatheory.com/computers/databases/postgresql/neither-null-nor-not-null.html

Thanks for the help, everyone.

Best,

David


In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2009-07-28 19:25:02
Subject: Re: system timezone regression failure
Previous:From: pgsqlDate: 2009-07-28 19:21:12
Subject: xpath not a good replacement for xpath_string

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