Re: return value from SQL statement - Mailing list pgsql-general

From Craig Ringer
Subject Re: return value from SQL statement
Date
Msg-id 47E90613.3020703@postnewspapers.com.au
Whole thread Raw
In response to return value from SQL statement  ("Alain Roger" <raf.news@gmail.com>)
Responses Re: return value from SQL statement  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: return value from SQL statement
Next
From: Decibel!
Date:
Subject: Re: Create user trigger?