diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-06-03 21:07:12 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-06-03 21:07:21 -0400 |
| commit | b4c027b5f52f029ac85d5743a5df85a955dd1ffe (patch) | |
| tree | 56fba93ded0ed46a69ef41e307d0c9ee2541e879 /doc/src | |
| parent | 6131cb144f8483fdc2223c1e06ce80e7c4ddf056 (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/intarray.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml index 956c01d7493..fdeedc6409e 100644 --- a/doc/src/sgml/intarray.sgml +++ b/doc/src/sgml/intarray.sgml @@ -453,7 +453,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}'; |