Re: polymorphic arguments and return type for PL/pgSQL

Поиск
Список
Период
Сортировка
Искать
От
Joe Conway
Тема
Re: polymorphic arguments and return type for PL/pgSQL
Дата
Msg-id
3F00842F.4010508@joeconway.com
Ответ на
Список
Дерево обсуждения
polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Tom Lane <tgl@sss.pgh.pa.us>
Re: polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Tom Lane <tgl@sss.pgh.pa.us>
Re: polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Joe Conway <mail@joeconway.com>
Re: polymorphic arguments and return type for PL/pgSQL Tom Lane <tgl@sss.pgh.pa.us>
Tom Lane wrote:
> The latter.  By the time you pay the price of a hash lookup, a slightly
> longer key is nearly free.  (Maybe entirely free, since it might produce
> better-distributed hash values.)

OK -- I figured that's what you'd say, so I've already started down that 
road.

> dynahash only supports fixed-length keys, so don't forget to zero out
> unused positions in the argument type vector.

Important safety tip! Thanks.

> BTW, I can't see any need to include the return type in the hash key ---
> wouldn't it be predetermined given the argument types?

Yup, very true.

Thanks,

Joe

В списке pgsql-patches по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ