Re: creating a function with a variable table name

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