Howdy,
I've a series of timestamp columns I'd like to alias in select statements. psql indicates my alias doesnt exist after
I define it.
Example -> select to_char(impressions_create_date,'yyyy-mm-dd') as ymd from impressionsdb where ymd like '2016-11%' ;
psql always complains column ymd does not exist. I've inherited a series of tables with many timestamps and would like to
shorten the select in queries without renaming any columns.
postgresql 9.2 on Gentoo 4.4.26
TIA, TRB
