Regarding select distinct ...query

Поиск
Список
Период
Сортировка
От Prachi Jain
Тема Regarding select distinct ...query
Дата
Msg-id 20021218164036.30595.qmail@webmail18.rediffmail.com
обсуждение исходный текст
Ответы Re: Regarding select distinct ...query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Linux folders permission - postgresql
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: To many connections Error