pgsql: Fix BRIN operator family definitions

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix BRIN operator family definitions
Date: 2014-11-28 21:10:46
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

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.



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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Noah Misch 2014-11-29 17:43:04 pgsql: Revert "Add libpq function PQhostaddr()."
Previous Message Alvaro Herrera 2014-11-28 21:07:39 pgsql: Update transaction README for persistent multixacts