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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
