Re: PREPARE function

On Tue, Nov 02, 2004 at 10:25:40AM -0800, Ion Chalmers Freeman wrote:

> Say my function name was redefeat and it took one varchar.
> > prepare redefeat(varchar);
> doesn't work; nor does
> > prepare vote (varchar) as redefeat;
> or
> > prepare(execute redefeat('Bush');
> What is the syntax for prepare? The man page is not sufficiently clear
> for me.

If you want to use a prepared statement then do this:

PREPARE plan_name (varchar) AS SELECT func_name($1);
EXECUTE plan_name ('some string');

If you just want to call the function once then SELECT should suffice:

SELECT func_name('some string');

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/