On Mar 23, 2005, at 8:51 AM, Shaun Clements wrote:
Hi Sean
Ive chosen the table structure on purpose.
Im transforming data from one table to another. The problem is still there.
I receive the column name from a query in one table, and then need to update the table with that column name in another.
This needs to be done dynamically as part of a loop. So the column name needs to be called as a variable.
Im stuck.
The answer is here to allow you to construct SQL statements from parts:
http://www.postgresql.org/docs/current/static/plpgsql- statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
You can pass your column name as an argument to a function that does what you want and then concatenate it with whatever else you want in your SQL. Then just EXECUTE the resulting statement.
Sean
---------------------------(end of broadcast)--------------------------- TIP 3: 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
