[PATCH] indexability of << operator for inet/cidr

Поиск
Список
Период
Сортировка
Attached is a patch that explains to optimizer that its possible to use
index when performing a << b where a is an inet/cidr value and b is a
constant.

Indexpath generated for such an expression is this:
(a > network(b)) and (a <= set_masklen(broadcast(b, 32)))

Since this is my first time delving in the guts of postgres, someone
definitely should review it :)

I mostly based my code on prefix_quals function for string types.

Thanks


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

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Update on Access 97 and = NULL
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Doing authentication in backend