aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2024-03-21 18:27:49 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2024-03-21 18:27:49 -0400
commit485f0aa85995340fb62113448c992ee48dc6fff1 (patch)
tree2b9e02fa44574ed74930f369ea50e536c098ce02 /doc/src
parent0997e0af273d80add75bcf5616eee000d0a78397 (diff)
downloadpostgresql-485f0aa85995340fb62113448c992ee48dc6fff1.tar.gz
postgresql-485f0aa85995340fb62113448c992ee48dc6fff1.zip
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
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ltree.sgml8
1 files changed, 8 insertions, 0 deletions
diff --git a/doc/src/sgml/ltree.sgml b/doc/src/sgml/ltree.sgml
index 00a6ae70da3..9584105b03b 100644
--- a/doc/src/sgml/ltree.sgml
+++ b/doc/src/sgml/ltree.sgml
@@ -625,6 +625,13 @@ Europe &amp; Russia*@ &amp; !Transportation
</listitem>
<listitem>
<para>
+ Hash index over <type>ltree</type>:
+ <literal>=</literal>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
GiST index over <type>ltree</type> (<literal>gist_ltree_ops</literal>
opclass):
<literal>&lt;</literal>, <literal>&lt;=</literal>, <literal>=</literal>,
@@ -712,6 +719,7 @@ INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Galaxies');
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Astronauts');
CREATE INDEX path_gist_idx ON test USING GIST (path);
CREATE INDEX path_idx ON test USING BTREE (path);
+CREATE INDEX path_hash_idx ON test USING HASH (path);
</programlisting>
<para>