PostgreSQL 14.10 DocumentationInterface Definition ............................................................. 2471 62.1. Basic API Structure for Indexes ................................................................ 2471 62.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); 191 Data Types The non-default GIN operator class jsonb_path_ops does not support @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 3032 页 | 13.27 MB | 1 年前3
PostgreSQL 14.10 DocumentationMethod Interface Definition ....................................................... 2338 62.1. Basic API Structure for Indexes .......................................................... 2338 62.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2871 页 | 13.38 MB | 1 年前3
PostgreSQL 13.13 DocumentationMethod Interface Definition ....................................................... 2254 61.1. Basic API Structure for Indexes .......................................................... 2254 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2782 页 | 13.00 MB | 1 年前3
PostgreSQL 12.17 DocumentationMethod Interface Definition ....................................................... 2259 61.1. Basic API Structure for Indexes .......................................................... 2259 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2786 页 | 12.72 MB | 1 年前3
PostgreSQL 12.17 DocumentationInterface Definition ............................................................. 2389 61.1. Basic API Structure for Indexes ................................................................ 2389 61.2. Index example of creating an index with this operator class is: 189 Data Types CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2943 页 | 12.61 MB | 1 年前3
PostgreSQL 13.14 DocumentationInterface Definition ............................................................. 2387 61.1. Basic API Structure for Indexes ................................................................ 2387 61.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2940 页 | 12.89 MB | 1 年前3
PostgreSQL 9.6.24 Documentation.............................................672 25.3.3. Making a Base Backup Using the Low Level API .........................................673 25.3.3.1. Making a non-exclusive low level backup .. Definition ............................................................................2263 59.1. Basic API Structure for Indexes ............................................................................ Table 9-43.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator0 码力 | 2814 页 | 6.58 MB | 1 年前3
PostgreSQL 9.6.24 Documentation
.............................................637 25.3.3. Making a Base Backup Using the Low Level API ..................................638 25.3.3.1. Making a non-exclusive low level backup ......... Definition .....................................................................2140 59.1. Basic API Structure for Indexes .........................................................................2140 Table 9-43.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator0 码力 | 2661 页 | 6.53 MB | 1 年前3
PostgreSQL 10.23 DocumentationInterface Definition ............................................................. 2193 60.1. Basic API Structure for Indexes ................................................................ 2193 60.2. Index Table 9.44.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator operator only. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2727 页 | 11.93 MB | 1 年前3
PostgreSQL 10.23 DocumentationMethod Interface Definition ....................................................... 2087 60.1. Basic API Structure for Indexes .......................................................... 2087 60.2. Index Access Table 9.44.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator example of creating an index with this operator class is: 162 Data Types CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved0 码力 | 2590 页 | 12.03 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4













