returned value from SQL statement - Mailing list pgsql-general

From Alain Roger
Subject returned value from SQL statement
Date
Msg-id 75645bbb0803270230n6af280a3pd2f14dcfcb096488@mail.gmail.com
Whole thread Raw
Responses Re: returned value from SQL statement
Re: returned value from SQL statement
Re: returned value from SQL statement
List pgsql-general
hi,

i would like to know how can i control the returned value from a SQL statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if there is another error ? where can i get a complete list of exceptions ?

2. if the INSERT INTO is successful, how can i know it ? what is the returned value ?

3. the same question as point 2 but for all SQL statements from PostgreSQL.

I read few books and every time this part is not treated correctly but only partially.

thanks a lot,

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008

pgsql-general by date:

Previous
From: Tommy Gildseth
Date:
Subject: Re: Performance of update
Next
From: Richard Huxton
Date:
Subject: Re: Using tables in other PostGreSQL database