Tom Lane wrote:
Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> writes:
I have recently run across situations that might benefit from the
ability to create a temporary function.
You can do that today, as long as you don't mind schema-qualifying
uses of the function:
regression=# create function pg_temp.tfunc(int) returns int as
regression-# $$ select $1 + 1 $$ language sql;
Excellent. I've submitted this as a comment to the docs for the next
time someone googles "CREATE TEMPORARY FUNCTION".
Cheers,
Steve