Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
67.2. Built-in Operator Classes
Prev UpChapter 67. GIN IndexesHome Next

67.2. Built-in Operator Classes

The corePostgres Pro distribution includes theGIN operator classes shown inTable 67.1. (Some of the optional modules described inAppendix F provide additionalGIN operator classes.)

Table 67.1. Built-inGIN 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 typejsonb,jsonb_ops is the default.jsonb_path_ops supports fewer operators but offers better performance for those operators. SeeSection 8.14.4 for details.


Prev Up Next
67.1. Introduction Home 67.3. Extensibility
pdfepub
Go to Postgres Pro Standard 15
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp