Kouhei Sutou
null+****@clear*****
Tue Jun 6 14:35:14 JST 2017
Kouhei Sutou 2017-06-06 14:35:14 +0900 (Tue, 06 Jun 2017) New Revision: 7b26e3a37665f38115c6ed4c247a49ad54aa75aa https://github.com/pgroonga/pgroonga.github.io/commit/7b26e3a37665f38115c6ed4c247a49ad54aa75aa Message: match-v2: add more information Modified files: reference/operators/match-v2.md Modified: reference/operators/match-v2.md (+20 -4) =================================================================== --- reference/operators/match-v2.md 2017-06-05 00:26:21 +0900 (cdec1a8) +++ reference/operators/match-v2.md 2017-06-06 14:35:14 +0900 (f328655) @@ -15,9 +15,25 @@ upper_level: ../ column &@ keyword ``` -`column` is a column to be searched. +`column` is a column to be searched. It's `text` type, `text[]` type or `varchar` type. -`keyword` is a keyword for full text search. It's `text` type. +`keyword` is a keyword for full text search. It's `text` type for `text` type or `text[]` type `column. It's `varchar` type for `varchar` type `column`. + +## Operator classes + +You need to specify one of the following operator classes to use this operator: + + * `pgroonga.text_full_text_search_ops`: Default for `text`. + + * `pgroonga.text_array_full_text_search_ops`: Default for `text[]`. + + * `pgroonga.varchar_full_text_search_ops`: For `varchar`. + + * `pgroonga.text_full_text_search_ops_v2`: For `text`. + + * `pgroonga.text_array_full_text_search_ops_v2`: For `text[]`. + + * `pgroonga.varchar_full_text_search_ops_v2`: For `varchar`. ## Usage @@ -51,10 +67,10 @@ SELECT * FROM memos WHERE content &@ 'engine'; If you want to perform full text search with multiple keywords or AND/OR search, use [`&?` operator](query-v2.html). -If you want to perform full text search with multiple keywords OR search, use [`&@>` operator](match-in-v2.html). +If you want to perform full text search with multiple keywords OR search, use [`&@|` operator](match-in-v2.html). ## See also * [`&?` operator](query-v2.html) - * [`&@>` operator](match-in-v2.html) + * [`&@|` operator](match-in-v2.html) -------------- next part -------------- HTML����������������������������...Download