Regarding select distinct ...query

From: "Prachi Jain" <prachijain3(at)rediffmail(dot)com>
To: christoph(dot)dalitz(at)hs-niederrhein(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Regarding select distinct ...query
Date: 2002-12-18 16:40:36
Message-ID: 20021218164036.30595.qmail@webmail18.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have a select query with select distinct....this query is giving
me error as "unable to identify ordering operator '<' for type
'unknown'"

when i used this query without distinct, it works fine.
What is actually happening?? Can anyone fed some light on
it...???

SELECT prod_chain.depot_sending as depot_sending,
prod_chain.depot_sending as description,
'' as part,
visual_sc.xpos as xpos,
visual_sc.ypos as ypos,
visual_sc.vlevel as depthlevel,
visual_sc.parent_hpos as hparent,
visual_sc.node_hpos as hnode,
visual_sc.visible as nodevisible,
visual_sc.nameshown as nameshown,
0 as parentindex
FROM prod_chain LEFT OUTER JOIN visual_sc
ON ( TRIM (trailing '' from prod_chain.depot_receiving ) =
TRIM( trailing '' from visual_sc.parent_depot ) ) and
( TRIM( trailing '' from prod_chain.depot_sending ) =
TRIM( trailing '' from visual_sc.child_depot ) ) WHERE
( ( TRIM( trailing '' from prod_chain.depot_receiving )
= '' ) AND
( TRIM( trailing '' from visual_sc.initiator_depot )
= '' ) AND
( TRIM( trailing '' from visual_sc.initiator_part ) = '' )
AND
( TRIM( trailing '' from visual_sc.user_id ) = '' ) AND
( TRIM( trailing '' from visual_sc.sc_type ) = 'B'
)AND
visual_sc.vlevel = 2 AND
visual_sc.parent_hpos = 0
)

Thanks and regards,
Prachi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-12-18 16:44:44 Re: To many connections Error
Previous Message Tom Lane 2002-12-18 16:10:58 Re: Linux folders permission - postgresql