Kevin Grittner wrote:
Peter Eisentraut <pete...@gmx.net> wrote:
This would become much simpler if you could just execute plpgsql
code instead of having to define a function around it.
I have often wished for that feature.
You're not Robinson Crusoe.
It could be done in several ways.
One fairly simple way would use a new SQL verb (say, DO) like this:
DO $$ something in plfoo$ $ LANGUAGE plfoo;
We could even default the langauge to plpgsql, for which you would then
just need:
DO $$ something in plpgsql $$;
The something would in effect be treated as a throwaway function taking
no parameters and returning void.
But to make it really nice you'd have to move away from pl programs as
strings. That would be a lot more work, and you really wouldn't want to
make it work with more than one PL for the sake of everyone's sanity.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
