2014-09-17 22:07 GMT+02:00 Vik Fearing <vik.fear...@dalibo.com>: > 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); > > That won't work; see above. > -- > Vik >