2016-08-16 21:50 GMT+02:00 Jim Nasby <Jim.Nasby@xxxxxxxxxxxxxx>:
On 8/16/16 11:17 AM, Chris Travers wrote:
I am thinking adding a temporary keyword to functions would make a lot
more sense.
Well, right now that's just syntactic sugar, so I think the only real benefit might be visibility (though, really we should be marketing the idea that you can create almost *any* object in pg_temp!).
What would be a lot more interesting is if creating a temp function didn't involve writing an entry to the catalog (something being discussed for temp tables right now).
Oracle has interesting temporary function defined inside CTE
Pavel
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
