Re: Can a function be parameter in PL/PGSQL function? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Can a function be parameter in PL/PGSQL function?
Date
Msg-id b42b73150701310603q5d58f270n7b41a1e651f4dd00@mail.gmail.com
Whole thread Raw
In response to Can a function be parameter in PL/PGSQL function?  ("Karen Hill" <karen_hill22@yahoo.com>)
List pgsql-general
On 30 Jan 2007 12:32:04 -0800, Karen Hill <karen_hill22@yahoo.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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Any Plans for cross database queries on the same server?
Next
From: Rich Shepard
Date:
Subject: Re: DBMS Engines and Performance