Обсуждение: pgsql: Fix BRIN operator family definitions

Поиск
Список
Период
Сортировка

pgsql: Fix BRIN operator family definitions

От
Alvaro Herrera
Дата:
Fix BRIN operator family definitions

The original definitions were leaving no room for cross-type operators,
so queries that compared a column of one type against something of a
different type were not taking advantage of the index.  Fix by making
the opfamilies more like the ones for Btree, and include a few
cross-type operator classes.

Catalog version bumped.

Per complaints from Hubert Lubaczewski, Mark Wong, Heikki Linnakangas.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/816e10d80033dd74b3b76fdfd84dffb767316c54

Modified Files
--------------
src/include/catalog/catversion.h  |    2 +-
src/include/catalog/pg_amop.h     |  132 +++++++++++++++++------
src/include/catalog/pg_amproc.h   |  213 ++++++++++++++++++++++++++++---------
src/include/catalog/pg_opclass.h  |   10 +-
src/include/catalog/pg_opfamily.h |   13 +--
5 files changed, 275 insertions(+), 95 deletions(-)