Carlo Stonebanks wrote: > (I suppose one possibility would be something that created a temporary > stored proc to execute the code, then cleaned up after itself.) Yep, that's what I do - CREATE FUNCTION fred() RETURNS blah AS $$ $$ LANGUAGE 'plpgsql'; SELECT fred(); DROP FUNCTION fred(); I've only needed it a couple of times in really complex data conversion and import routines, though. It'd be really quite nice to have CREATE TEMPORARY FUNCTION even if Pg didn't have true anonymous blocks (which IMO encourage unnecessary procedural style coding). -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
