"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.
regards, tom lane