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 Dunstan||Date: 2009-07-28 19:25:02|
|Subject: Re: system timezone regression failure|
|Previous:||From: pgsql||Date: 2009-07-28 19:21:12|
|Subject: xpath not a good replacement for xpath_string|