order by is ambiguous - Mailing list pgsql-general

From Travel Jadoo
Subject order by is ambiguous
Date
Msg-id 1073571904.11264.6.camel@server
Whole thread Raw
Responses Re: order by is ambiguous  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Optimize query: time of "single * IN(many)" > time
Next
From: Tom Lane
Date:
Subject: Re: Compile problem on old Debian Linux with glibc 2.0.7