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.
Any suggestions
Use pl/tcl/perl/python or similar rather than plpgsql - it's not good for this sort of thing. Pick whichever language you are most familiar with, they should all cope fine with this sort of problem.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
