Kouhei Sutou
null+****@clear*****
Wed Jun 7 15:00:19 JST 2017
Kouhei Sutou 2017-06-07 15:00:19 +0900 (Wed, 07 Jun 2017) New Revision: 2627a488979c71df5f24cb12f7fe0a603ed6e135 https://github.com/pgroonga/pgroonga.github.io/commit/2627a488979c71df5f24cb12f7fe0a603ed6e135 Message: match-in-v2: add more information Modified files: reference/operators/match-in-v2.md Modified: reference/operators/match-in-v2.md (+13 -3) =================================================================== --- reference/operators/match-in-v2.md 2017-06-07 14:51:49 +0900 (63a48ec) +++ reference/operators/match-in-v2.md 2017-06-07 15:00:19 +0900 (a99fb09) @@ -17,12 +17,22 @@ upper_level: ../ column &@| keywords ``` -`column` is a column to be searched. +`column` is a column to be searched. It's `text` type, `text[]` type or `varchar` type. -`keywords` is an array of keywords for full text search. It's `text[]` type. +`keywords` is an array of keywords for full text search. It's `text[]` type for `text` type or `text[]` type `column`. It's `varchar[]` for `varchar` type `column`. The operator returns `true` when one or more keyword in `keywords` are included in `column`. +## Operator classes + +You need to specify one of the following operator classes to use this operator: + + * `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 Here are sample schema and data for examples: @@ -67,4 +77,4 @@ SELECT * FROM memos WHERE content &@| ARRAY['engine', 'database']; [match-v2]:match-v2.html [query-v2]:query-v2.html -[query-in-v2]:query-v2.html +[query-in-v2]:query-in-v2.html -------------- next part -------------- HTML����������������������������...Download
