| From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
|---|---|
| To: | gianpaolo <gianpaolo(at)preciso(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Passing tables as parameter |
| Date: | 2001-01-07 01:23:53 |
| Message-ID: | 01010620235319.09559@comptechnews |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Can I see your function that tried to do it? Pg 7.1 beta has a new EXECUTE
statement for PL/pgSQL that allows execution of a query string that can be
created dynamically (see the development docs at www.postgresql.org) It
might be relevant to your problem.
On Friday 05 January 2001 03:59, gianpaolo wrote:
> Short question:
> is it possible to pass tables names as parameter in FUNCTION?
> I tried with SQL function as well as with PLPGSQL but I couldn't do it.
> Did I do something wrong or is it impossible?
> Thanks a lot
>
> gianpaolo racca
> gianpaolo(at)preciso(dot)net
--
-------- Robert B. Easter reaster(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett W. McCoy | 2001-01-07 01:32:53 | Re: Outer Joins |
| Previous Message | Tom Lane | 2001-01-07 01:21:31 | Re: Outer Joins |