Re: [GENERAL] Capturing return value of a function

- Original Message - From: Jasbinder Singh Bali To: pgsql-general@postgresql.org Sent: Monday, July 16, 2007 3:55 PM Subject: [GENERAL] Capturing return value of a function I was wondering what would the function return if insert fails. I want it to return 'success' upon a succes

Re: [GENERAL] Capturing return value of a function

"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes: > I was wondering what would the function return if insert fails. It would abort immediately and abort your transaction as well unless something higher up catches the error. > I want it to return 'success' upon a successful insert and 'failure

Re: [GENERAL] Capturing return value of a function

On Jul 16, 2007, at 15:55 , Jasbinder Singh Bali wrote: 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. Depends on what you mean by "failed". Do you mean an error was raised? Then you'l

Re: [GENERAL] Capturing return value of a function in Pl/Perl

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I'm calling a plpgsql function in a plperl function. > plpgsql function is a simple select query returning a single row of records. > How can i retrieve the values of different fields in my plperl function? Please check out the page: http://