Re: Passing tables as parameter - Mailing list pgsql-general

From Robert B. Easter
Subject Re: Passing tables as parameter
Date
Msg-id 01010620235319.09559@comptechnews
Whole thread Raw
In response to Passing tables as parameter  (gianpaolo <gianpaolo@preciso.net>)
Responses Re: Passing tables as parameter
List 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@preciso.net

--
-------- Robert B. Easter  reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------

pgsql-general by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: Outer Joins
Next
From: Tom Lane
Date:
Subject: Re: Outer Joins