Skip site navigation (1) Skip section navigation (2)

Re: status variables

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: status variables
Date: 2004-12-15 03:39:56
Message-ID: 20041215033956.M66902@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
> 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


In response to

pgsql-novice by date

Next:From: Lola LeeDate: 2004-12-15 11:31:57
Subject: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Previous:From: Michael FuhrDate: 2004-12-15 03:00:24
Subject: Re: status variables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group