In response to "Bob Pawley" <rjpawley(at)shaw(dot)ca>:
>
> I want to add information to multiple columns (20 – 40) by employing a loop. Each pass of the loop will populate one column with an array.
>
> I have tried and I have read that variables can not be used to control column names.
>
> Is there a means of working around this restriction other than creating 20 to 40 hard coded statements??
You can generate dynamic SQL statements with plpgsql.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/