|
|
 | | From: | KÖPFERL_Robert | | Subject: | Re: Returning a bool on DELETE in a proc. | | Date: | Wed, 19 Jan 2005 18:09:16 +0100 |
|
|
 | It's ... hm
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?
I'm capable to learn.
> -----Original Message-----
> From: Michael Fuhr [mailto:mike@fuhr.org]
> Sent: Mittwoch, 19. Jänner 2005 18:02
> To: KÖPFERL Robert
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Returning a bool on DELETE in a proc.
>
>
> On Wed, Jan 19, 2005 at 11:24:26AM +0100, KÖPFERL Robert wrote:
>
> > Seems that I forgot to mention that this function is
> intended to be written
> > in SQL, not in PL/SQL.
>
> Why SQL instead of PL/pgSQL if the former doesn't do what you need
> and the latter does?
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
|
| | From: | Michael Fuhr | | Subject: | Re: Returning a bool on DELETE in a proc. | | Date: | Wed, 19 Jan 2005 14:35:21 -0700 |
|
|
| 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/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
|
|
