>
> 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.
David J.