Re: select function alias

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

On Wed, Nov 30, 2016 at 8:15 AM, btober@xxxxxxxxxxxx <btober@xxxxxxxxxxxxxxx> wrote:

5. Use a CTE:

    with shortnames as (

        select to_char(impressions_create_date,'yyyy-mm-dd') as ymd from impressionsdb 

) select ymd from shortnames where ymd like '2016-11%';

​Except that WHERE clause won't get pushed down (I think...haven't checked an explain recently) so a sub-select is definitely better in this scenario.

David J.