calling a plpgsql procedure

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

Responses

Browse pgsql-general by date

  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