Joshua D. Drake wrote:
>>
>> As for implementation, I think it would obviously be best to leave
>> plpgsql on its own as a PL but maybe change BEGIN and DECLARE in the
>> normal parser and have the system generate/execute a function on the
>> fly. Or, maybe it would be better to integrate plpgsql. Or, I may
>> just be crazy.
>>
>> Would anyone else ever benefit from inline functions?
>
>
> Well I could see inline functions being useful for debugging a
> function during development but I don't think I would want a bunch of
> plPGSQL mucking up my pretty SQL :)
>
>
Then don't put it there ;-)
I think you'd need to do something like this:
PERFORM language plpgsql $$
-- some plpgsql stuff here
$$;
cheers
andrew