On 09/16/2014 10:09 AM, Heikki Linnakangas wrote: > On 09/16/2014 10:57 AM, Craig Ringer wrote: >> On 09/16/2014 03:15 PM, Pavel Stehule wrote: >> >>> Why we don't introduce a temporary functions instead? >> >> I think that'd be a lot cleaner and simpler. It's something I've >> frequently wanted, and as Hekki points out it's already possible by >> creating the function in pg_temp, there just isn't the syntax sugar for >> "CREATE TEMPORARY FUNCTION". >> >> So why not just add "CREATE TEMPORARY FUNCTION"? > > Sure, why not.
Because you still have to do
SELECT pg_temp.my_temp_function(blah);
to execute it.
this problem should be solvable. I can to use a temporary tables without using pg_temp schema.
Pavel
>> It means two steps: >> >> CREATE TEMPORARY FUNCTION ... $$ $$; >> >> SELECT my_temp_function(blah);