Re: [GENERAL] return value from SQL statement

Alain Roger wrote: 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 ... Given the table: CREATE TABLE testtable ( blah VARCHAR, CONSTRAINT blah_is_unique UNIQUE(bla

Re: [GENERAL] return value from SQL statement

On Tue, 25 Mar 2008 16:38:04 +0100 "Alain Roger" <[EMAIL PROTECTED]> wrote: > 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

Re: [GENERAL] return value from SQL statement

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

Re: [GENERAL] 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?

[GENERAL] return value from SQL statement

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 ? thx. -- Alain Windows XP SP2 PostgreSQL 8.2.4 / MS SQL server 2005 Apache 2.2.4 PHP 5.2.4 C# 2