Re: select function alias - Mailing list pgsql-general

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

1. Use the same to_char expression in the where clause
2. Use a sub-select to use the alias in the outer where clause
3. Use the original column in the where clause and use the timestamp comparisson functions.

Howard.