Re: [GENERAL] creating a function with another function

2009-10-12 Thread David Fetter
On Mon, Oct 12, 2009 at 03:36:47PM -0500, Dave Huber wrote: > > Surely, there are valid cases of having a function create a > > function. Suppose (just off the top of my head), you create a > > helper function that generates triggers on a table for record > > archiving. > > My application is for

Re: [GENERAL] creating a function with another function

2009-10-12 Thread Dave Huber
> Surely, there are valid cases of having a function create a function. > Suppose (just off the top of my head), you create a helper function > that generates triggers on a table for record archiving. My application is for archiving. I'm using partitioned tables (each 10 records) to keep a ro

Re: [GENERAL] creating a function with another function

2009-10-12 Thread Merlin Moncure
On Mon, Oct 12, 2009 at 3:41 PM, David Fetter wrote: > On Mon, Oct 12, 2009 at 02:12:35PM -0500, Dave Huber wrote: >> Is it possible to execute a CREATE OR REPLACE FUNCTION with another >> function or even have a function modify itself? > > Yes, but doing any of that is a sign that you're working

Re: [GENERAL] creating a function with another function

2009-10-12 Thread David Fetter
On Mon, Oct 12, 2009 at 02:12:35PM -0500, Dave Huber wrote: > Is it possible to execute a CREATE OR REPLACE FUNCTION with another > function or even have a function modify itself? Yes, but doing any of that is a sign that you're working with a broken design. That, or you're looking to make an ent

[GENERAL] creating a function with another function

2009-10-12 Thread Dave Huber
Is it possible to execute a CREATE OR REPLACE FUNCTION with another function or even have a function modify itself? Dave This electronic mail message is intended exclusively for the individual(s) or entity to which it is addressed. This message, together with an