Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViteU-0001eS-CO for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 22:20:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1ViteT-0005jm-Sz for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 22:20:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViteS-0005j9-Ms for pgsql-general@postgresql.org; Tue, 19 Nov 2013 22:20:08 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViteL-00029l-IR for pgsql-general@postgresql.org; Tue, 19 Nov 2013 22:20:08 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1ViteI-0000nh-Q4 for pgsql-general@postgresql.org; Tue, 19 Nov 2013 14:19:58 -0800 Date: Tue, 19 Nov 2013 14:19:58 -0800 (PST) From: David Johnston To: pgsql-general@postgresql.org Message-ID: <1384899598791-5779269.post@n5.nabble.com> In-Reply-To: <1384899064.80953.YahooMailNeo@web162904.mail.bf1.yahoo.com> References: <1384899064.80953.YahooMailNeo@web162904.mail.bf1.yahoo.com> 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=UTF-8 Content-Transfer-Encoding: quoted-printable 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 Kevin Grittner-5 wrote > gajendra s v < > svgajendra@ > > wrote: >=20 >> 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 >=20 > The UNION operation requires comparing all columns in the result > record to remove duplicates.=C2=A0 To identify duplicates, there must be > a notion of equality defined (getting technical here) by a default > btree opclass for the type.=C2=A0 XML does not have one, so UNION of a > result set including an XML column is not allowed. >=20 > Do you need the duplicate removal?=C2=A0 If not, use UNION ALL.=C2=A0 If = you > need that you may need to cast the XML to text for intermediate > steps and then cast back to XML at the outermost level. The other option is to only union the PK field(s) on KM_COURSE_MAST then as a final outer query join that union-ed result back with KM_COURSE_MAST using the PK and attach whatever additional columns your query desires. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/org-p= ostgresql-util-PSQLException-ERROR-could-not-identify-an-equality-operator-= for-type-xml-tp5779042p5779269.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general