hstore: add hstore_length function

Поиск
Список
Период
Сортировка
От Korbin Hoffman
Тема hstore: add hstore_length function
Дата
Msg-id CAE2W21M=2nPbFb9aYLeAypZiQnV-GxuRp2mOoRcurrTPuYGtTw@mail.gmail.com
обсуждение исходный текст
Ответы Re: hstore: add hstore_length function  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Список pgsql-hackers
Hi there-

I've attached a small patch exposing HS_COUNT to the user as
"hstore_length(hstore)". Documentation, upgrade sql files, and a few
tests are also included.

Almost every hstore function calls HS_COUNT, but I couldn't determine
if there was a reason this exposure didn't already exist.

Without this function, I've been converting an hstore into an array
and then counting it - a more expensive operation (~30-40% slower than
SELECTing the hstore itself in a few of my tests).

I will add this thread and patch to the next Commitfest.

Thanks,
Korbin Hoffman

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vik Fearing
Дата:
Сообщение: Re: Rename synchronous_standby_names?
Следующее
От: Thom Brown
Дата:
Сообщение: chkpass_in should not be volatile