From: | Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: inconsistency in aliasing |
Date: | 2009-01-14 11:27:48 |
Message-ID: | 20090114112748.GA5569@apartia.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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>"
From | Date | Subject | |
---|---|---|---|
Next Message | dbalinglung | 2009-01-14 11:31:55 | Re: inconsistency in aliasing |
Previous Message | A. Kretschmer | 2009-01-14 11:06:47 | Re: inconsistency in aliasing |
From | Date | Subject | |
---|---|---|---|
Next Message | dbalinglung | 2009-01-14 11:31:55 | Re: inconsistency in aliasing |
Previous Message | A. Kretschmer | 2009-01-14 11:06:47 | Re: inconsistency in aliasing |