Postgres Pro
Downloads
Home   >   mailing lists

Re: using a plpgsql function argument as a table column. - Mailing list pgsql-general

From David G. Johnston
Subject Re: using a plpgsql function argument as a table column.
Date
Msg-id CAKFQuwYQNcOUVNsW_MXgpVYgeuqOc8Kp03duUaW7g57hoEZTfw@mail.gmail.com
Whole thread Raw
In response to Re: using a plpgsql function argument as a table column.  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
On Tuesday, August 28, 2018, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

2018-08-29 7:09 GMT+02:00 Shaun Savage <savages@taxnvote.org>:
I have a table with many years as columns. y1976, y2077, .. , y2019,y2020 I want to dynamically return a column from a function.

Personally, your design is unahappy - against to ideas of relations databases. So any native tools will be impossible.

+1

I don’t know for sure that what is desired is not possible but only because the specification and model are more than I wish to untangle at the moment...

David J.
 

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: using a plpgsql function argument as a table column.
Next
From: Alexander Kukushkin
Date:
Subject: Re: WAL replay issue from 9.6.8 to 9.6.10