| From: | Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | inconsistency in aliasing |
| Date: | 2009-01-14 10:46:11 |
| Message-ID: | 20090114104611.GA4168@apartia.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reg Me Please | 2009-01-14 11:01:23 | Re: inconsistency in aliasing |
| Previous Message | Reg Me Please | 2009-01-14 10:40:52 | A better BETWEEN for DATEs, TIMEs and TIMESTAMPs? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reg Me Please | 2009-01-14 11:01:23 | Re: inconsistency in aliasing |
| Previous Message | Heikki Linnakangas | 2009-01-14 09:56:21 | Re: Assertion failure in plpgsql with INSTEAD OF rule |