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