Thread: status variables

status variables

From
"Keith Worthington"
Date:
Hi All,

When executing a query in PostgreSQL v7.3.6 are any variables set that
indicate the status of that query?  Success/Failure, Number of rows retrieved,
Number of records written, etc.  If not is this functionality provided in a
later release?  Where can I find the documentation that describes these variables?

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com


Re: status variables

From
Michael Fuhr
Date:
On Tue, Dec 14, 2004 at 09:11:24PM -0500, Keith Worthington wrote:

> When executing a query in PostgreSQL v7.3.6 are any variables set that
> indicate the status of that query?  Success/Failure, Number of rows retrieved,
> Number of records written, etc.  If not is this functionality provided in a
> later release?  Where can I find the documentation that describes these variables?

Whether query status is available and how to access it depends on
the interface you're using (libpq, Perl + DBI, ECPG, PL/pgSQL, etc.)
and should be described in that interface's documentation.  What
interface are you using?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: status variables

From
"Keith Worthington"
Date:
> On Tue, Dec 14, 2004 at 09:11:24PM -0500, Keith Worthington wrote:
>
> > When executing a query in PostgreSQL v7.3.6 are any variables
> > set that  indicate the status of that query?  Success/Failure,
> > Number of rows retrieved, Number of records written, etc.  If
> > not is this functionality provided in a later release?  Where
> > can I find the documentation that describes these variables?
>
> Whether query status is available and how to access it depends on
> the interface you're using (libpq, Perl + DBI, ECPG, PL/pgSQL, etc.)
> and should be described in that interface's documentation.  What
> interface are you using?
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/

Thanks again Michael.  You have once again given me a nudge in the right
direction.  I found what I needed at
http://www.postgresql.org/docs/7.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

I can now continue on towards my goal of writing a procedure to move data from
one table to another. :-)

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com