Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Can a function be parameter in PL/PGSQL function?
- From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
- To: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Can a function be parameter in PL/PGSQL function?
- Date: Wed, 31 Jan 2007 09:03:03 -0500
On 30 Jan 2007 12:32:04 -0800, Karen Hill <karen_hill22(at)yahoo(dot)com> wrote:
Is it possible to have a pl/pgsql function take another pl/pgsql function as one of the parameters?
not exactly. you can take a string and execute it via dynamic sql, but this is going to cause problems with record and array types and generally just uglify your code. If you want to implement a callback, you can improvise one if you are willing to cut a little C: http://archives.postgresql.org/pgsql-performance/2005-11/msg00012.php I've followed this mechanism, and it works... merlin
- References:
- Can a function be parameter in PL/PGSQL function?
- From: Karen Hill
- Can a function be parameter in PL/PGSQL function?
- Prev by Date: Re: Any Plans for cross database queries on the same server?
- Next by Date: Re: DBMS Engines and Performance
- Previous by thread: Re: Can a function be parameter in PL/PGSQL function?
- Next by thread: 8.2.1 Compiling Error
- Indexes: