Re: calling a plpgsql procedure
От | Robert Treat |
---|---|
Тема | Re: calling a plpgsql procedure |
Дата | |
Msg-id | 1024957695.1648.60.camel@camel обсуждение исходный текст |
Ответ на | calling a plpgsql procedure (s <smarie@ekno.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: