| From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
|---|---|
| To: | "Bill Moran" <wmoran(at)potentialtech(dot)com> |
| Cc: | "Postgresql" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Variable column name |
| Date: | 2011-09-01 15:04:49 |
| Message-ID: | 69597773E704449891C6CA5267B2DD6D@BobPC |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)shaw(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2011-09-01 15:13:37 | Re: Variable column name |
| Previous Message | Bill Moran | 2011-09-01 14:59:35 | Re: Variable column name |