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