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

From ss
Subject using a plpgsql function argument as a table column.
Date
Msg-id 837526ef-2ea4-5569-9d01-1e56b82037bf@tuxclub.org
Whole thread Raw
Responses Re: using a plpgsql function argument as a table column.
Re: using a plpgsql function argument as a table column.
List pgsql-general
I have a table with many years as columns. y1976, y2077, .. , 
y2019,y2020 I want to dynamically return a column from a function.


select * from FUNCTION('y2016') .....

select t1.cola t1.colb, t1.colc, t2.y2016 from ..... Where t2.y2016 != 0;

or if I select year y2012 I want FUNCTION('y2012')

select t1.cola t1.colb, t1.colc, t2.y2012 from ..... Where t2.y2012 != 0;


to generalize

select * from FUNCTION( year_column )

select t1.cola t1.colb, t1.colc, t2.year_column from ..... Where 
t2.year_column != 0;

is it possible? if so how?



pgsql-general by date:

Previous
From: Shaun Savage
Date:
Subject: using a plpgsql function argument as a table column.
Next
From: Thomas Boussekey
Date:
Subject: Re: using a plpgsql function argument as a table column.