From: | s <smarie(at)ekno(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | calling a plpgsql procedure |
Date: | 2002-06-24 17:47:06 |
Message-ID: | 1024940826.3d175b1a401f8@www.ekno.lonelyplanet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)ekno(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-06-24 17:48:33 | Re: Need help on index!!! |
Previous Message | Andrew Sullivan | 2002-06-24 17:44:29 | Some Solaris notes, and an invitation |