Tom Lane <tgl@sss.pgh.pa.us> writes:
> "Prachi Jain" <prachijain3@rediffmail.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