Re: return value from SQL statement

Alain Roger wrote:
> 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 ?
>
>
The answer depends entirely on how you're using the database.

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