Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> "Prachi Jain" <prachijain3(at)rediffmail(dot)com> writes:
> > I have a select query with select distinct....this query is giving
> > me error as "unable to identify ordering operator '<' for type
> > 'unknown'"
>
> Try casting the '' to some specific datatype, like varchar or text.
I ran into precisely the same issue here yesterday. This works perfectly fine
in Oracle, does the standard really leave "select distinct 'foo'" undefined?
--
greg