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

Thanks for the help, everyone.



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-2017 The PostgreSQL Global Development Group