On Sat, Jul 23, 2011 at 1:32 PM, David Johnston <pol...@yahoo.com> wrote: > >> >> Now for the application, you can create an API that is semantically >> clearer. But PostgreSQL doesn't provide an easy way of calling >> procedures of this sort out of select/update/insert statements and >> select is the only way to do this. >> >> > > A semantically accurate way to run "procedures" is: > > DO $$ BEGIN PERFORM function(); END $$; > > It would be nice if you could use PERFORM outside of plpgsql... > > Now, this is not standard SQL but it does convey the desired semantics. That > said, proper function naming can convey similar semantic information as well.
The other option (one we try to follow in LedgerSMB) is to always make the procedure return useful information. So you are essentially calling a procedure and selecting the result for further use by your application. Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
