Re: Hash Support Function - Mailing list pgsql-general

From Tom Lane
Subject Re: Hash Support Function
Date
Msg-id 31075.1378564022@sss.pgh.pa.us
Whole thread Raw
In response to Hash Support Function  (Soroosh Sardari <soroosh.sardari@gmail.com>)
List pgsql-general
Soroosh Sardari <soroosh.sardari@gmail.com> writes:
> I'm developing a new type, and want to have hash index on it.
> I must write a hash function for the new type, according to the PG manual,
> section 35.14.3.
> However, there is no example for this function. Actually signature of the
> hash support function
> would be sufficient for me.

hashfunc(yourtype) returns integer strict immutable

For examples see hashint4, hashfloat8, hashtext, and many others.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Constraint exclusion and overlapping range checks
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: Is this a bug in ECPG?