Skip to content

Commit b4c027b

Browse files
committed
Doc: fix bogus intarray index example.
The siglen parameter is provided by gist__intbig_ops not gist__int_ops. Simon Norris Discussion: https://postgr.es/m/11BF2AA9-17AE-432A-AFE1-584FB9FB079D@hillcrestgeo.ca
1 parent 6131cb1 commit b4c027b

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

doc/src/sgml/intarray.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -453,7 +453,7 @@
453453
CREATE TABLE message (mid INT PRIMARY KEY, sections INT[], ...);
454454

455455
-- create specialized index with signature length of 32 bytes
456-
CREATE INDEX message_rdtree_idx ON message USING GIST (sections gist__int_ops(siglen=32));
456+
CREATE INDEX message_rdtree_idx ON message USING GIST (sections gist__intbig_ops (siglen = 32));
457457

458458
-- select messages in section 1 OR 2 - OVERLAP operator
459459
SELECT message.mid FROM message WHERE message.sections && '{1,2}';

0 commit comments

Comments
 (0)