-----Original Message-----
From: Bill Moran
Sent: Thursday, September 01, 2011 7:59 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: Variable column name
In response to "Bob Pawley" <rjpawley@xxxxxxx>:
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??
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
