Re: creating a function with a variable table name

[George Nychis <gnychis@xxxxxxx>]

do I need to use PREPARE with it also?

A. Kretschmer wrote:
> am  Thu, dem 01.03.2007, um 11:17:46 -0500 mailte George Nychis folgendes:
> > Hey all,
> >
> > I'm trying to create a function in which the table a query is run on is 
> > variable, but I guess this is not as easy as I thought.
> >
> > BEGIN
> > dp=> CREATE FUNCTION stats_addr_dst(date,text)
> > ...
> > dp'>       FROM $2
> >                    ^
> > How can I pass the table name?
>
> Build a string with your SQL and EXECUTE this string.
>
>
> Andreas