Re: help with a procedure

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: help with a procedure
Date: 2014-06-05 18:28:13
Message-ID: 1401992893163-5806242.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carlos Carcamo wrote
> SELECT myProcedure(product_id, p_description, price, qty, store_id,
> store_description );
>
> waiting for a response from procedure, maybe true or false.

Note that forcing the procedure to return false instead of simply throwing
an error is going to degrade performance. If you can live with
silence=success; error=failure it will be much easier to program and will
achieve maximum performance.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/help-with-a-procedure-tp5806213p5806242.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-06-05 18:46:11 Re: Heartbleed Impact
Previous Message Sébastien Lorion 2014-06-05 18:09:50 Re: Merge a sharded master into a single read-only slave