e.g :
0 is everything is completed
-1 if searched data already exist into table
-2 if insert into failed
...
later i would like to use this returned value in my PHP (this i know how to do)
is it clearer ?
A.
On Tue, Mar 25, 2008 at 3:02 PM, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote:
Alain Roger wrote:The answer depends entirely on how you're using the database.
> Hi,
>
> i have a 'insert into' statement and i would like to know if it fails or
> not.
> i was thinking to check the resturn value from this statement, but how to do
> it ?
>
>
ODBC?
JDBC?
Perl DBD?
Python with psycopg?
SQL code read by the psql command?
Also, by "failure", do you mean "encountered an error that terminated
the transaction" or "inserted zero rows" ?
--
Craig Ringer
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
