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:
Соглашаюсь с условиями обработки персональных данных