Re: New data type: uniqueidentifier - Mailing list pgsql-hackers

From Dmitry G. Mastrukov
Subject Re: New data type: uniqueidentifier
Date
Msg-id 001101c1003d$931ad9a0$016ba8c0@taurussoft.org
Whole thread Raw
In response to Re: New data type: uniqueidentifier  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-hackers
 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Dmitry G. Mastrukov" <dmitry@taurussoft.org> writes:
> > Alex Pilosov <alex@pilosoft.com> wrote:
> >> On Tue, 26 Jun 2001, Dmitry G. Mastrukov wrote:
> > I've marked "=" operator with HASH clause (and planner has started to
> > use
> > hash jons). But as I understand the right way is to create special hash
> > function (may be wrapper for hash_any(), isn't it?) and register it for
> > hash
> > as for btree method.
> >>
> >> No. Currently, there's no way to specify a hash function for a given
> >> operator, it always uses a builtin function that operates on memory
> >> representation of a value.
>
> > Strange. When I execute following query (slightly modified query from
User's
> > Guide chapter 7.6)
>
> You're looking at support for hash indexes, which have nothing to do
> with hash joins.
>
> *Why* they have nothing to do with hash joins, I dunno.  You'd think
> that using the same hash functions for both would be a good idea.
> But that's not how it's set up at the moment.
>
OK. It's clear for me now. Thanks.
But should I create support for hash indexes? Since builtin types have such
support I want it too for uniqueidentifier :) How can I make it?

regards,
Dmitry



pgsql-hackers by date:

Previous
From: Mike Cianflone
Date:
Subject: Order of triggers
Next
From: Joseph Weinstein
Date:
Subject: Re: JDBC Connection State Management with SQL Exceptions (esp Postgresql)