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.
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 |