Re: status variables

> 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