gajendra s v <svgajendra@xxxxxxxxx> 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. To identify duplicates, there must be a notion of equality defined (getting technical here) by a default btree opclass for the type. XML does not have one, so UNION of a result set including an XML column is not allowed. Do you need the duplicate removal? If not, use UNION ALL. 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
