pgsql: Add hash support functions and hash opclass for contrib/ltree.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add hash support functions and hash opclass for contrib/ltree.
Date: 2024-03-21 22:28:04
Message-ID: E1rnQtI-004zzt-7c@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add hash support functions and hash opclass for contrib/ltree.

This also enables hash join and hash aggregation on ltree columns.

Tommy Pavlicek, reviewed by jian he

Discussion: https://postgr.es/m/CAEhP-W9ZEoHeaP_nKnPCVd_o1c3BAUvq1gWHrq8EbkNRiS9CvQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/485f0aa85995340fb62113448c992ee48dc6fff1

Modified Files
--------------
contrib/ltree/Makefile | 3 +-
contrib/ltree/expected/ltree.out | 68 ++++++++++++++++++++++++++++++++++++++
contrib/ltree/ltree--1.2--1.3.sql | 23 +++++++++++++
contrib/ltree/ltree.control | 2 +-
contrib/ltree/ltree_op.c | 69 +++++++++++++++++++++++++++++++++++++++
contrib/ltree/ltreetest.sql | 1 +
contrib/ltree/meson.build | 3 +-
contrib/ltree/sql/ltree.sql | 47 ++++++++++++++++++++++++++
doc/src/sgml/ltree.sgml | 8 +++++
9 files changed, 221 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Daniel Gustafsson 2024-03-21 22:33:15 pgsql: Fix dumping role comments when using --no-role-passwords
Previous Message Alexander Korotkov 2024-03-21 21:01:18 pgsql: Add TupleTableSlotOps.is_current_xact_tuple() method