Re: returned value from SQL statement

thanks for the link regarding errors... i did not find it before.

On Thu, Mar 27, 2008 at 10:47 AM, Richard Huxton <dev(at)archonet(dot)com> wrote:

> 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
>

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