Re: Regarding select distinct ...query - Mailing list pgsql-general

From Tom Lane
Subject Re: Regarding select distinct ...query
Date
Msg-id 3770.1040231217@sss.pgh.pa.us
Whole thread Raw
In response to Regarding select distinct ...query  ("Prachi Jain" <prachijain3@rediffmail.com>)
Responses Re: Regarding select distinct ...query  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Conxita Marín
Date:
Subject: Re: SELECT EXTRACT doesn't work with variables?
Next
From: Tom Lane
Date:
Subject: Re: Table Timemachine!