In response to "Bob Pawley" <rjpaw...@shaw.ca>: > > From: Bill Moran > > 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. > > Would it be possible for you to point me to an example??
http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html Section 39.5.4 If you're not familiar with plpgsql at all, you might want to start with this: http://www.postgresql.org/docs/9.0/static/plpgsql-structure.html -- 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
