under pl/pgsql language i would like to return a function value. 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 <[EMAIL PROTECTED]> wrote: > 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 > -- Alain ------------------------------------ Windows XP SP2 PostgreSQL 8.2.4 / MS SQL server 2005 Apache 2.2.4 PHP 5.2.4 C# 2005-2008
