On Sun, Feb 20, 2011 at 02:31:46PM -0500, Tom Lane wrote: > Karsten Hilbert <Karsten.Hilbert@xxxxxxx> writes: > > On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote: > >> Unfortunately I do not understand why PostgreSQL says > >> > >> psql:xx.sql:14: ERROR: could not implement UNION > >> DETAIL: Some of the datatypes only support hashing, while others only support sorting. > > > The solution lies in these bits: > > >> pk_context | integer[] | > > > This data type can only be hashed. > > >> xmin_message_inbox | xid | > > > This data type can only be sorted. > > ITYM the other way round, right? Indeed :-) > As of 9.1 there will be support for hashing arrays, so this particular > problem should go away without hacks. Great. PG is getting better by the day :-) Anyway, I consider the "explicit cast" not really that bad of a hack. Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
