Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vif0v-0007Tw-ML for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 06:42:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vif0v-00054m-5F for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 06:42:21 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vif0t-00054d-MO for pgsql-general@postgresql.org; Tue, 19 Nov 2013 06:42:19 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vif0q-0005lh-V2 for pgsql-general@postgresql.org; Tue, 19 Nov 2013 06:42:18 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Vif0p-0005YP-MT for pgsql-general@postgresql.org; Mon, 18 Nov 2013 22:42:15 -0800 Date: Mon, 18 Nov 2013 22:42:15 -0800 (PST) From: David Johnston To: pgsql-general@postgresql.org Message-ID: <1384843335585-5779044.post@n5.nabble.com> In-Reply-To: References: Subject: Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.8 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org gajendra s v wrote > 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 XML has no concept of equality though I do not see any obvious use of an XML column in the supplied query. Is there maybe a view involved you are not telling us about? Are you positive it's this query that has the problem? Your report is short on specifics - like the name of the XML column you added and on what table, for instance. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/org-postgresql-util-PSQLException-ERROR-could-not-identify-an-equality-operator-for-type-xml-tp5779042p5779044.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general