From: | gajendra s v <svgajendra(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml |
Date: | 2013-11-19 06:27:39 |
Message-ID: | CAHjig8_uudM=qYo1e9yVuG+FZpFD4NRLRdBJgOOMEGV+cx+sDA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-11-19 06:42:15 | Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml |
Previous Message | bricklen | 2013-11-19 05:15:54 | Re: ERROR: out of memory DETAIL: Failed on request of size ??? |