Thread: PREPARE function

PREPARE function

From
ionFreeman@gmail.com (Ion Chalmers Freeman)
Date:
So, I wrote a little function. Yay! I went to the dbExperts prompt
(I'm on Windows XP) and created it. Yay! Now, I'd like to run it.
> \i pg_MyFile.sql
this bit works great. But, the next bit, I'm having a problem with.
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. Here it is:
http://www.postgresql.org/docs/7.4/interactive/sql-prepare.html
Please help! What would the syntax be?
Ion

Re: PREPARE function

From
Michael Fuhr
Date:
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/