Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VitVq-0001MJ-HO for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 22:11:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VitVp-0000Uo-7A for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2013 22:11:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VitVo-0000Ue-2P for pgsql-general@postgresql.org; Tue, 19 Nov 2013 22:11:12 +0000 Received: from nm44-vm3.bullet.mail.bf1.yahoo.com ([216.109.114.254]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VitVj-00021Y-MJ for pgsql-general@postgresql.org; Tue, 19 Nov 2013 22:11:10 +0000 Received: from [66.196.81.174] by nm44.bullet.mail.bf1.yahoo.com with NNFMP; 19 Nov 2013 22:11:04 -0000 Received: from [98.139.212.197] by tm20.bullet.mail.bf1.yahoo.com with NNFMP; 19 Nov 2013 22:11:04 -0000 Received: from [127.0.0.1] by omp1006.mail.bf1.yahoo.com with NNFMP; 19 Nov 2013 22:11:04 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 886389.19717.bm@omp1006.mail.bf1.yahoo.com Received: (qmail 85071 invoked by uid 60001); 19 Nov 2013 22:11:04 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1384899064; bh=PpFnCJ21bOcCu5J2y0/qGReYoBK+HmFcbaN7StVUbiM=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2Y3XFa0VtWS2XRMrMLRDZsW7Wdnm0gVxucL6KcC8crAaH+zrqt526J0xjoO5h8Ysv8+e879VCtuiXQPixuTZO1cchnWMYHxkkwIaTrV/S2hWGczlrHK8NZ1FMUHrD5bD8XcSFKO8ZAwawLLCahYpn5ZrzWAfb70qpT1Yrla3JMg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=bLjr+zN3zWzAiBgmSLGPC2ybwYh0rZ3FM6irkI4vdHPZRi51/rjDrKxya6Y2H8g9R5Tvoasjc1+oQ8ui5EMRnPWGqG/0P9tlgcEr+9djAxobZVg7/9yK4TWkcj6GSw4RzUXUPRSJ0pgsa6KJCmVhe8mpnbHLkOGI/ecjC9RPq8U=; X-YMail-OSG: 7XU1AOkVM1nIQUE9kitvdsaCDuTdPIzCmN83GPB.P7q0PsT 7k19LkkLWqdZxgpxjTTko3x71OBtzvvyqU4r1YHiQLhCeE4GUJKcCq.UJK8V 6dlDst9IGrNEdAXYn2QU5I.JX7ZL7FglvISFuxgK9FqiZElruHfRJX18pyz0 1X7pf4wS9OUMul4cnnT4kemkfRhuccgFpeyrSmjJaE.z0ZuGhaqyQ3seA376 1fP5tNxFlB9izqbudZiZy3cA6xCUsgOKYeAS8eg_Ibe4YLi.PvwT0Imjpkdq BeA79jYPltbFvOIu59kJUS0s.HJIaB3L0HgaSYtL08jMZH_TQUkemLfVDAza fVbY.KmOSESg27iHXMr4MDJhtUZfgjPjkR7NeQYIjJRHh63vbWwN4AguqFDp 7bvJDcs1UTVa7LMjmpXZ3RGPcyUkNnTizNw_1sq0FrFACq2xXl.KvQeOfn5x tYPlwexa94ioXR937wKWDHpKMo7lXz5Mt1poFUaU9UdT0NsAQuo.0gPAqiHz eOZYKKvOd2.aqVheUCtuV0bRMVD6nQMOC.S87JUTcY65iLlfMFPBREJnUWip x.JfkNhF1sO9ZsxRj1CAJTN2sVGaWkq90xuIKvju7i5hP24U93Irqyzxdot1 v0g-- Received: from [76.255.18.237] by web162904.mail.bf1.yahoo.com via HTTP; Tue, 19 Nov 2013 14:11:04 PST X-Rocket-MIMEInfo: 002.001, Z2FqZW5kcmEgcyB2IDxzdmdhamVuZHJhQGdtYWlsLmNvbT4gd3JvdGU6Cgo.IEkgaGF2ZSBhZGRlZCBvbmUgY29sdW1uIHdpdGggeG1sIHR5cGUgLGFmdGVyIGFkZGluZyBJIGFtIGdldHRpbmcKPiBmb2xsb3dpbmcgZXJyb3IuCj4KPiBvcmcucG9zdGdyZXNxbC51dGlsLlBTUUxFeGNlcHRpb246IEVSUk9SOiBjb3VsZCBub3QgaWRlbnRpZnkgYW4gZXF1YWxpdHkgb3BlcmF0b3IgZm9yIHR5cGUgeG1sCgpUaGUgVU5JT04gb3BlcmF0aW9uIHJlcXVpcmVzIGNvbXBhcmluZyBhbGwgY29sdW1ucyBpbiB0aGUgcmUBMAEBAQE- X-Mailer: YahooMailWebService/0.8.166.601 References: Message-ID: <1384899064.80953.YahooMailNeo@web162904.mail.bf1.yahoo.com> Date: Tue, 19 Nov 2013 14:11:04 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml To: gajendra s v , "pgsql-general@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) 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: > 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 The UNION operation requires comparing all columns in the result record to remove duplicates.=A0 To identify duplicates, there must be a notion of equality defined (getting technical here) by a default btree opclass for the type.=A0 XML does not have one, so UNION of a result set including an XML column is not allowed. Do you need the duplicate removal?=A0 If not, use UNION ALL.=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. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general