Re: Hash Support Function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hash Support Function
Дата
Msg-id 31075.1378564022@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Hash Support Function  (Soroosh Sardari <soroosh.sardari@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Constraint exclusion and overlapping range checks
Следующее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: Is this a bug in ECPG?