On Jun 23, 2007, at 22:47 , gary jefferson wrote:
Is there a way to use a variable as the name of a table or column
in plpgsql?
AIUI, you need to use EXECUTE and build the query string yourself.
http://www.postgresql.org/docs/8.2/interactive/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Take a look at the quote_ident function as well:
http://www.postgresql.org/docs/8.2/interactive/functions-string.html
Hope this helps you get started.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
