diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-03-21 18:27:49 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-03-21 18:27:49 -0400 |
commit | 485f0aa85995340fb62113448c992ee48dc6fff1 (patch) | |
tree | 2b9e02fa44574ed74930f369ea50e536c098ce02 /doc/src | |
parent | 0997e0af273d80add75bcf5616eee000d0a78397 (diff) | |
download | postgresql-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.sgml | 8 |
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 & Russia*@ & !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><</literal>, <literal><=</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> |