From: | Simon Norris <snorris(at)hillcrestgeo(dot)ca> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | intarray doc example fix |
Date: | 2021-06-03 20:55:02 |
Message-ID: | 11BF2AA9-17AE-432A-AFE1-584FB9FB079D@hillcrestgeo.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Hi list,
I noticed a very small problem in the intarray docs example.
Trying out the example gives below error, the example uses the wrong parameter for the given operator class:
db=# CREATE TABLE message (mid INT PRIMARY KEY, sections INT[]);
CREATE TABLE
db=# CREATE INDEX message_rdtree_idx ON message USING GIST (sections gist__int_ops(siglen=32));
ERROR: unrecognized parameter "siglen"
I'm not familiar with emailing patches, diff of suggested fix is below.
thanks
Simon
diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml
index dfe98279c0..7b809a3519 100644
--- a/doc/src/sgml/intarray.sgml
+++ b/doc/src/sgml/intarray.sgml
@@ -446,7 +446,7 @@
CREATE TABLE message (mid INT PRIMARY KEY, sections INT[], ...);
-- create specialized index with signature length of 32 bytes
-CREATE INDEX message_rdtree_idx ON message USING GIST (sections gist__int_ops(siglen=32));
+CREATE INDEX message_rdtree_idx ON message USING GIST (sections gist__intbig_ops(siglen=32));
-- select messages in section 1 OR 2 - OVERLAP operator
SELECT message.mid FROM message WHERE message.sections && '{1,2}';
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-06-04 00:08:55 | Has the Update savepoint example outlived its usefulness? |
Previous Message | Emre Hasegeli | 2021-06-03 12:57:24 | Re: Note that ALTER TABLE cannot alter generated stored columns |