From: | ludwig(at)kni-online(dot)de |
---|---|
To: | Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: inconsistency in aliasing |
Date: | 2009-01-14 11:02:03 |
Message-ID: | 2120557778.1009341.1231930923745.JavaMail.webmailer@webmail.1and1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't know, if this is an inconsistence or a bug, but here a possible workaround:
select current_timestamp::abstime::int4 as score, current_timestamp::abstime::int4 + 1 as "score + 1" order by "score + 1";
Ludwig
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 ...
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2009-01-14 11:06:47 | Re: inconsistency in aliasing |
Previous Message | Reg Me Please | 2009-01-14 11:01:23 | Re: inconsistency in aliasing |