Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: creating a function with a variable table name
Date
Msg-id 20070301163939.GA29828@a-kretschmer.de
Whole thread Raw
In response to creating a function with a variable table name  (George Nychis <gnychis@cmu.edu>)
Responses Re: creating a function with a variable table name  (George Nychis <gnychis@cmu.edu>)
List pgsql-general
Tree view 
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
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Jan Muszynski"
Date:
Subject: ftell mismatch with expected position
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Constructors for dates, times, and timestamps