Re: Passing tables as parameter

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

In response to

Responses

Browse pgsql-general by date

  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