From 485f0aa85995340fb62113448c992ee48dc6fff1 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Thu, 21 Mar 2024 18:27:49 -0400
Subject: 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
---
 contrib/ltree/ltreetest.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'contrib/ltree/ltreetest.sql')

diff --git a/contrib/ltree/ltreetest.sql b/contrib/ltree/ltreetest.sql
index d6996caf3c4..388d5bb6f5c 100644
--- a/contrib/ltree/ltreetest.sql
+++ b/contrib/ltree/ltreetest.sql
@@ -19,3 +19,4 @@ 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);
-- 
cgit v1.2.3

