Re: using a plpgsql function argument as a table column.

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tuesday, August 28, 2018, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:

Hi

2018-08-29 7:09 GMT+02:00 Shaun Savage <savages@xxxxxxxxxxxx>:

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.