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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org