Re: inconsistency in aliasing
| От | dbalinglung |
|---|---|
| Тема | Re: inconsistency in aliasing |
| Дата | |
| Msg-id | C33CB97C7C624D558CFE18559248A623@alam обсуждение исходный текст |
| Ответ на | inconsistency in aliasing (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>) |
| Ответы |
Re: inconsistency in aliasing
|
| Список | 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
>
> 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 по дате отправления: