org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml
От | gajendra s v |
---|---|
Тема | org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml |
Дата | |
Msg-id | CAHjig8_uudM=qYo1e9yVuG+FZpFD4NRLRdBJgOOMEGV+cx+sDA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: org.postgresql.util.PSQLException: ERROR: could not identify an
equality operator for type xml
Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml |
Список | pgsql-general |
Hi All,
I have added one column with xml type ,after adding I am getting following error.
org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml
If I have removed column following query works fine
select * from (select * from KM_COURSE_MAST where ID in (select OBJ_ID from (select OBJ_ID,PERFORMER_TYPE,PERFORMER_ID from KM_REL_OBJ_PER_ACTION where OBJ_TYPE='COURSETYPE') g where PERFORMER_TYPE='GROUP' and PERFORMER_ID in ((WITH RECURSIVE parents as ( select PARENT_ID from KM_REL_SELF_GROUP where CHILD_ID in ( SELECT GROUP_ID FROM KM_REL_GRP_USER WHERE USER_ID=46467) UNION select a.PARENT_ID FROM KM_REL_SELF_GROUP a ,parents p where a.CHILD_ID = p.PARENT_ID ) select PARENT_ID from parents order by PARENT_ID asc)union SELECT GROUP_ID FROM KM_REL_GRP_USER WHERE USER_ID=46467)) union select * from KM_COURSE_MAST where CREATED_BY='46467') KM_COURSE_MAST order by DISPLAYORDER
Thanks,
Gajendra
В списке pgsql-general по дате отправления: