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. >> It means two steps: >> >> CREATE TEMPORARY FUNCTION ... $$ $$; >> >> SELECT my_temp_function(blah); That won't work; see above. -- Vik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers