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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to