| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Returning a bool on DELETE in a proc. |
| Date: | 2005-01-19 21:35:21 |
| Message-ID: | 20050119213521.GA95945@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Jan 19, 2005 at 06:09:16PM +0100, KÖPFERL Robert wrote:
> >
> > Why SQL instead of PL/pgSQL if the former doesn't do what you need
> > and the latter does?
>
> I have the feeling that even complicated and boxed queries are faster or can
> be optimized by the planer than any PLpgsql. Isn't there a motule that has
> to be invoked?
PL/pgSQL might be more efficient than you think -- see the Overview
in the PL/pgSQL documentation for more information about how it
works. I'd suggest making the function work first, and only then
worry about whether it's fast enough.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | none none | 2005-01-19 22:03:52 | include in both ecpg and C++ |
| Previous Message | Joel Fradkin | 2005-01-19 20:50:30 | ERROR: row is too big: size 9856, maximum size 8136 |