Re: Stored Procedure performance / elegance question

Karen Hill wrote:
> x-no-archive:yes
>
> Hello.
>
> I have a stored procedure which returns a setof record. The function
> takes a few arguments, and if a couple of specific input values are
> null, it is required that the stored procedure perform different
> actions.
>
> I know that the planner does not store the plan when EXECUTE is used in
> a function, but the function looks better when the sql is created
> dynamically.
>
>
Karen,
My particular opinion on this is to only use execute if you need it.
If you don't need it don't use it.
A example where you would need execute is if you wanted to create a new
user from inside a function with a passed in username.
Another example where you would need EXECUTE is if you are working with
temp tables in a function.

Later,

--

Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration