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/