In response to "Bob Pawley" <rjpaw...@shaw.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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
