Thread: PL/PgSQL GET DIAGNOSTICS command

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,
Pennsylvania19026
 

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

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/

> 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,
Pennsylvania19026