Re: Variable column name - Mailing list pgsql-general

-----Original Message-----
From: Bill Moran
Sent: Thursday, September 01, 2011 7:59 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name

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 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/