order by is ambiguous

From: Travel Jadoo <jadoo(at)xs4all(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: order by is ambiguous
Date: 2004-01-08 14:25:05
Message-ID: 1073571904.11264.6.camel@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I could not find any discussion on this but imho this seems an erroneous
error occuring now in 7.3.4 (after upgrade from 7.2.3):

select null::time, 'test'::varchar as time order by time;
ERROR: ORDER BY 'time' is ambiguous

The solution is to name the time datatype e.g.

select null::time as xyz, 'test'::varchar as time order by time;

Regards,
Alfred

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-08 14:57:04 Re: Compile problem on old Debian Linux with glibc 2.0.7
Previous Message Alvaro Herrera 2004-01-08 11:44:27 Re: Optimize query: time of "single * IN(many)" > time