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