Alain Roger wrote:
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 ?
If it fails you'll get an error. The transaction will be aborted. How
you access this error code will depend on what library/client you are using.
3. the same question as point 2 but for all SQL statements from PostgreSQL.
Same.
I read few books and every time this part is not treated correctly but only
partially.
There's a full list of error codes here if you want to know what went wrong:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html
Am I mis-understanding you?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
