intarray doc example fix
От | Simon Norris |
---|---|
Тема | intarray doc example fix |
Дата | |
Msg-id | 11BF2AA9-17AE-432A-AFE1-584FB9FB079D@hillcrestgeo.ca обсуждение исходный текст |
Ответы |
Re: intarray doc example fix
|
Список | 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}';
В списке pgsql-docs по дате отправления: