select update_cur_res('VALUE-HERE'); // should do the trick.
see also http://www.postgresql.org/idocs/index.php?plpgsql.html
Robert Treat
On Mon, 2002-06-24 at 13:47, s wrote:
> Sorry to post such a stupid question. I have read the "create
> function" documentation and searched old mailing lists, but I can't
> seem to find an example of how to call a plpgsql procedure that isn't
> associated with a trigger.
>
> In Oracle (old platform) I used:
>
> begin update_cur_res('VALUE-HERE'); end
>
> This doesn't work in postgres as far as I can tell. I've tried some
> other things as well and failed, such as
>
> psql $mydb
> > update_cur_res('VALUE-HERE');
>
> which gives a message that I have a syntax error near the semi-colon.
> Help?
>
> Thanks,
>
> Sarah Mulholland
> smarie@ekno.com
>
> P.S. Why does the "search documentation" option on the web page only
> accept 15 characters?
>
> ____________________________________________________________________________
> Lonely Planet's ekno - more than a phonecard
> Get ekno before you go!
> http://www.ekno.lonelyplanet.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
