From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/gin-builtin-opclasses.html | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 doc/src/sgml/html/gin-builtin-opclasses.html (limited to 'doc/src/sgml/html/gin-builtin-opclasses.html') diff --git a/doc/src/sgml/html/gin-builtin-opclasses.html b/doc/src/sgml/html/gin-builtin-opclasses.html new file mode 100644 index 0000000..6ad1bab --- /dev/null +++ b/doc/src/sgml/html/gin-builtin-opclasses.html @@ -0,0 +1,13 @@ + +70.2. Built-in Operator Classes
70.2. Built-in Operator Classes
Prev UpChapter 70. GIN IndexesHome Next

70.2. Built-in Operator Classes #

+ The core PostgreSQL distribution + includes the GIN operator classes shown in + Table 70.1. + (Some of the optional modules described in Appendix F + provide additional GIN operator classes.) +

Table 70.1. Built-in GIN Operator Classes

NameIndexable Operators
array_ops&& (anyarray,anyarray)
@> (anyarray,anyarray)
<@ (anyarray,anyarray)
= (anyarray,anyarray)
jsonb_ops@> (jsonb,jsonb)
@? (jsonb,jsonpath)
@@ (jsonb,jsonpath)
? (jsonb,text)
?| (jsonb,text[])
?& (jsonb,text[])
jsonb_path_ops@> (jsonb,jsonb)
@? (jsonb,jsonpath)
@@ (jsonb,jsonpath)
tsvector_ops@@ (tsvector,tsquery)
@@@ (tsvector,tsquery)

+ Of the two operator classes for type jsonb, jsonb_ops + is the default. jsonb_path_ops supports fewer operators but + offers better performance for those operators. + See Section 8.14.4 for details. +

Prev Up Next
70.1. Introduction Home 70.3. Extensibility
\ No newline at end of file -- cgit v1.2.3