In response to "Bob Pawley" <rjpawley@shaw.ca>:
>
> I want to add information to multiple columns (20 – 40) by employing a loop. Each pass of the loop will populate one
columnwith 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.comhttp://people.collaborativefusion.com/~wmoran/