Hashable custom types

From: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Hashable custom types
Date: 2014-04-25 23:47:49
Message-ID: CACowWR2zE=-awXtyZrjJDYRcfPZtN9gr7kkPPqVsXH_HT2tOkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

When trying to write a recursive CTE using the PostGIS geometry type,
I was told this:

ERROR: could not implement recursive UNION
DETAIL: All column datatypes must be hashable.

Is it possible to make custom types hashable? There's no hook in the
CREATE TYPE call for a hash function, but can one be hooked up
somewhere else? In an operator?

Thanks,

P

--
Paul Ramsey
http://cleverelephant.ca
http://postgis.net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-04-25 23:54:17 Re: Hashable custom types
Previous Message Andres Freund 2014-04-25 22:15:40 Decrease MAX_BACKENDS to 2^16