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

Calling functions indirectly using their name

From: evertcarton(at)netscape(dot)net (Evert Carton)
To: pgsql-novice(at)postgresql(dot)org
Subject: Calling functions indirectly using their name
Date: 2002-10-22 16:31:02
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
(I also this question to usenet comp.databases.postgresql.novice)

Hi all,

I was wondering ?

Is there a way to call a function if you have it's oid or it's name, but call it indirectly ?

What I'm trying to achieve is the following : 

I'd like to store a reference (the OID, or the name, since OID's can change) to an existing stored procedure in a table.
The referenced function/procedure would then be called by triggers.
Different records can point to the same procedure, and there can be a whole lot of procedures, and they will probably be in different languages, some SQL, some PGPLSQL, some C or TCL.  

Is there a way to call a  referenced functions ?
Or am I taking a silly approach ... 

Any help, pointers to documentation, ... would be greatly appreciated.


Evert Carton
Medical Research Laboratories

The NEW Netscape 7.0 browser is now available. Upgrade now! 

Get your own FREE, personal Netscape Mail account today at

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-10-22 16:36:42
Subject: Re: arc relationship [was: db design question]
Previous:From: Tan gaDate: 2002-10-22 13:35:47
Subject: Trying to avoid double results

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