On Wed, Nov 30, 2016 at 12:15 PM, David G. Johnston
wrote:
> On Wed, Nov 30, 2016 at 8:15 AM, bto...@computer.org
> wrote:
>>
>> 5. Use a CTE:
>>
>> with shortnames as (
>> select to_char(impressions_create_date,'-mm-dd') as ymd from
>> impressionsdb
>> ) select ymd from shortname
On Wed, Nov 30, 2016 at 8:15 AM, bto...@computer.org wrote:
> 5. Use a CTE:
>
> with shortnames as (
> select to_char(impressions_create_date,'-mm-dd') as ymd from
> impressionsdb
> ) select ymd from shortnames where ymd like '2016-11%';
>
>
​Except that WHERE clause won't get pus
- Original Message -
> From: "Howard News"
> Sent: Wednesday, November 30, 2016 9:03:28 AM
> Subject: Re: [GENERAL] select function alias
> On 30/11/2016 13:42, Timoteo Blanco wrote:
> > I've a series of timestamp columns I'd like to alias in se
On 30/11/2016 13:42, Timoteo Blanco wrote:
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,'-mm-dd') as ymd
from impressionsdb where ymd like '201
