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

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, Pennsylvania 19026