----- Original Message -----
From: Jasbinder Singh Bali
To: pgsql-general(at)postgresql(dot)org
Sent: Monday, July 16, 2007 3:55 PM
Subject: [GENERAL] Capturing return value of a function
<snip>
> I was wondering what would the function return if insert fails.
> I want it to return 'success' upon a successful insert and 'failure' if
> insert fails.
You can find out whether the insert was successful or not using the tools
here:
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
<snip>
Regards,
George