Re: Regarding select distinct ...query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Prachi Jain" <prachijain3(at)rediffmail(dot)com>
Cc: christoph(dot)dalitz(at)hs-niederrhein(dot)de, pgsql-general(at)postgresql(dot)org
Subject: Re: Regarding select distinct ...query
Date: 2002-12-18 17:06:57
Message-ID: 3770.1040231217@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-18 17:31:37 Re: Table Timemachine!
Previous Message Conxita Marín 2002-12-18 17:01:00 Re: SELECT EXTRACT doesn't work with variables?