dynamic SQL/plsql functions

From: Richard Harvey Chapman <hchapman(at)3gfp(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: dynamic SQL/plsql functions
Date: 2000-09-20 22:39:37
Message-ID: Pine.LNX.4.10.10009201508540.2124-100000@smirk.3gfp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a large list ot parameters and I'd like to have just one main
function for checking them all. Like so:

check_param(some_identifier_for_the_param, param_value)
...
rec RECORD;
...
select into rec check_param_function
from param_check_table
where id == identifier;

select rec.check_param_function(param_value) as result;
...

That's the general idea. Is there a way to dynamically call a plsql or sql
function? Is there a way to do what I have above (evaluating a string
before a SQL statement gets sent to postgres)?

Thanks,

R.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-09-21 01:23:58 Re: -S is missing in postgresql.conf?
Previous Message Jesus Sandoval 2000-09-20 20:35:54 Dynamic application data refreshing