Re: inconsistency in aliasing

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: "Louis-David Mitterrand" <vindex+lists-pgsql-general(at)apartia(dot)org>
Subject: Re: inconsistency in aliasing
Date: 2009-01-14 11:01:23
Message-ID: 200901141201.23496.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wednesday 14 January 2009 11:46:11 Louis-David Mitterrand wrote:
> 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,

Looks and smells like a bug.

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ludwig 2009-01-14 11:02:03 Re: inconsistency in aliasing
Previous Message Louis-David Mitterrand 2009-01-14 10:46:11 inconsistency in aliasing

Browse pgsql-hackers by date

  From Date Subject
Next Message A. Kretschmer 2009-01-14 11:06:47 Re: inconsistency in aliasing
Previous Message Louis-David Mitterrand 2009-01-14 10:46:11 inconsistency in aliasing