On Wed, Jan 14, 2009 at 05:53:57AM -0800, Lennin Caro wrote: > --- On Wed, 1/14/09, Louis-David Mitterrand <vindex+lists-pgsql-general@xxxxxxxxxxx> wrote: > > > From: Louis-David Mitterrand <vindex+lists-pgsql-general@xxxxxxxxxxx> > > Subject: Re: inconsistency in aliasing > > To: pgsql-general@xxxxxxxxxxxxxx > > Date: Wednesday, January 14, 2009, 11:27 AM > > On Wed, Jan 14, 2009 at 12:06:47PM +0100, A. Kretschmer > > wrote: > > > In response to Louis-David Mitterrand : > > > > 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 ? > > > > > > Yes, you can't use the alias in the ORDER BY. Use > > the real column-name. > > > > > > select current_timestamp::abstime::int4 as score order > > by > > > current_timestamp::abstime::int4; > > > > Did you try > > > > "select current_timestamp::abstime::int4 as score > > order by score;" ? > > > > This seems to be an "order by <alias>" > > > > -- > > http://www.critikart.net > > > > you can't use operator in the group by, try this Really? select current_timestamp::abstime::int4 as score order by 1 + 1 ; score ------------ 1231941662 (1 row) -- http://www.critikart.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
