Skip site navigation (1) Skip section navigation (2)

Create temporary function

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Create temporary function
Date: 2008-04-23 18:20:36
Message-ID: 480F7DF4.1000106@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-general
I have recently run across situations that might benefit from the 
ability to create a temporary function.

One situation is where periodic processing would benefit from 
server-side functions but the processing is run rarely (say monthly or 
annually) and the requirements for the function may change. This is 
relatively easily handled by a CREATE OR REPLACE..run..DROP FUNCTION but 
CREATE TEMPORARY FUNCTION would be cleaner.

The other is where it would be nice for a client to see an isolated 
individual copy of a function.

For me both of the above are minor nice-to-haves. I have no idea how 
difficult this would be to implement but in the spirit of brainstorming, 
I thought I'd throw it out to see if anyone else thinks it is a useful 
concept.

Cheers,
Steve


Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-04-23 18:33:52
Subject: Re: Create temporary function
Previous:From: Simon RiggsDate: 2008-04-23 18:15:52
Subject: Re: Need to update all my 60 million rows at oncewithout transactional integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group