Postgres Pro
Downloads
Home   >   mailing lists

Re: creating a function with a variable table name - Mailing list pgsql-general

From George Nychis
Subject Re: creating a function with a variable table name
Date
Msg-id 45E70386.8080900@cmu.edu
Whole thread Raw
In response to Re: creating a function with a variable table name  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: creating a function with a variable table name  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: George Nychis
Date:
Subject: get username of user calling function?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Why does "group by" need to match select fields?