Re: inconsistency in aliasing - Mailing list pgsql-general

From dbalinglung
Subject Re: inconsistency in aliasing
Date
Msg-id C33CB97C7C624D558CFE18559248A623@alam
Whole thread Raw
In response to inconsistency in aliasing  (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>)
Responses Re: inconsistency in aliasing  (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>)
List pgsql-general
what for of the syntax command  +1 on order by ? maybe just wrong to given result about the error query on order by, it's BUG ?
 
 
dbalinglung
 
DataproSoft Developer
 
 
----- Original Message -----
From: "Louis-David Mitterrand" <vindex+lists-pgsql-general@apartia.org>
Sent: Wednesday, January 14, 2009 5:46 PM
Subject: [GENERAL] inconsistency in aliasing

> Hi,
>
> This works:
>
> critik=# select current_timestamp::abstime::int4 as score order by score;
>
> This doesn't:
>
> critik=# select current_timestamp::abstime::int4 as score order by score + 1; 
> ERROR:  column "score" does not exist
> LINE 1: ...urrent_timestamp::abstime::int4 as score order by score + 1 ...
>
> Any idea ?
>
> Thanks,
>
> --
>
http://www.critikart.net
>

pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: Re: inconsistency in aliasing
Next
From: Louis-David Mitterrand
Date:
Subject: Re: inconsistency in aliasing