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.
>
> 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