Andrew Dunstan <andrew@dunslane.net> writes:
> One fairly simple way would use a new SQL verb (say, DO) like this:
> DO $$ something in plfoo $$ LANGUAGE plfoo;
Yeah, this has been suggested before. I can't see anything very wrong
with it.
> We could even default the langauge to plpgsql, for which you would then
> just need:
> DO $$ something in plpgsql $$;
Add a GUC variable to set the default language, perhaps?
> 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.
That would be an awful lot of messiness to save four keystrokes...
regards, tom lane