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: 588B4ED5.2C47589B.4B8A5395@netscape.net (view raw or flat)
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.

Regards,

Evert Carton
Medical Research Laboratories

__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

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-2014 The PostgreSQL Global Development Group