I see the new PL/PgSQL command:

	GET DIAGNOSTICS

This seems like a poorly-worded command to me.  It is meant to return
the number of rows affected by a previous query, right?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 9 Feb 2001 12:04:08 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
PL/PgSQL GET DIAGNOSTICS command
On Fri, Feb 09, 2001 at 12:04:08PM -0500, Bruce Momjian wrote:
> I see the new PL/PgSQL command:
> 
> 	GET DIAGNOSTICS
> 
> This seems like a poorly-worded command to me.  It is meant to return
> the number of rows affected by a previous query, right?

Among other things, eventually. You get to blame the SQL standards
committee, again:


wallace$ grep 'GET DIAGNOSTICS' sql1992.txt
              GET DIAGNOSTICS <sql diagnostics information>

Ross

Mon, 12 Feb 2001 10:28:35 -0600
"Ross J. Reedstrom" <reedstrm@rice.edu>
Re: PL/PgSQL GET DIAGNOSTICS command
Bruce Momjian writes:

> I see the new PL/PgSQL command:
>
> 	GET DIAGNOSTICS
>
> This seems like a poorly-worded command to me.  It is meant to return
> the number of rows affected by a previous query, right?

That's how SQL wants it.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Mon, 12 Feb 2001 17:43:26 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: PL/PgSQL GET DIAGNOSTICS command
> On Fri, Feb 09, 2001 at 12:04:08PM -0500, Bruce Momjian wrote:
> > I see the new PL/PgSQL command:
> > 
> > 	GET DIAGNOSTICS
> > 
> > This seems like a poorly-worded command to me.  It is meant to return
> > the number of rows affected by a previous query, right?
> 
> Among other things, eventually. You get to blame the SQL standards
> committee, again:
> 
> 
> wallace$ grep 'GET DIAGNOSTICS' sql1992.txt
>               GET DIAGNOSTICS <sql diagnostics information>
> 

That is unbelievable!  (But true.)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 12 Feb 2001 12:36:30 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PL/PgSQL GET DIAGNOSTICS command