Re: inconsistency in aliasing

["dbalinglung" <alamsurya@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxx>

To: <pgsql-general@xxxxxxxxxxxxxx>

Sent: Wednesday, January 14, 2009 5:46 PM

Subject: 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
>