Kouhei Sutou
null+****@clear*****
Wed Feb 4 22:31:25 JST 2015
Kouhei Sutou 2015-02-04 22:31:25 +0900 (Wed, 04 Feb 2015) New Revision: fa4a5754ded422885ca6b21e0fbbca89185f8072 https://github.com/pgroonga/pgroonga/commit/fa4a5754ded422885ca6b21e0fbbca89185f8072 Message: Split operator class for full text search Because we can't provide range index search for tokenized data. Modified files: pgroonga.sql Modified: pgroonga.sql (+15 -5) =================================================================== --- pgroonga.sql 2015-02-03 22:47:08 +0900 (4cf9f12) +++ pgroonga.sql 2015-02-04 22:31:25 +0900 (235abcb) @@ -183,7 +183,14 @@ INSERT INTO pg_catalog.pg_am VALUES( 'pgroonga.options' -- amoptions ); -CREATE OPERATOR CLASS pgroonga.text_ops DEFAULT FOR TYPE text +CREATE OPERATOR CLASS pgroonga.full_text_search_text_ops DEFAULT FOR TYPE text + USING pgroonga AS + OPERATOR 7 %%, + OPERATOR 8 @@, + FUNCTION 1 pgroonga.typeof(oid, integer), + FUNCTION 2 pgroonga.get_text(internal, internal, text); + +CREATE OPERATOR CLASS pgroonga.text_ops FOR TYPE text USING pgroonga AS OPERATOR 1 <, OPERATOR 2 <=, @@ -191,12 +198,17 @@ CREATE OPERATOR CLASS pgroonga.text_ops DEFAULT FOR TYPE text OPERATOR 4 >=, OPERATOR 5 >, OPERATOR 6 <>, + FUNCTION 1 pgroonga.typeof(oid, integer), + FUNCTION 2 pgroonga.get_text(internal, internal, text); + +CREATE OPERATOR CLASS pgroonga.full_text_search_bpchar_ops DEFAULT FOR TYPE bpchar + USING pgroonga AS OPERATOR 7 %%, OPERATOR 8 @@, FUNCTION 1 pgroonga.typeof(oid, integer), - FUNCTION 2 pgroonga.get_text(internal, internal, text); + FUNCTION 2 pgroonga.get_bpchar(internal, internal, bpchar); -CREATE OPERATOR CLASS pgroonga.bpchar_ops DEFAULT FOR TYPE bpchar +CREATE OPERATOR CLASS pgroonga.bpchar_ops FOR TYPE bpchar USING pgroonga AS OPERATOR 1 <, OPERATOR 2 <=, @@ -204,8 +216,6 @@ CREATE OPERATOR CLASS pgroonga.bpchar_ops DEFAULT FOR TYPE bpchar OPERATOR 4 >=, OPERATOR 5 >, OPERATOR 6 <>, - OPERATOR 7 %%, - OPERATOR 8 @@, FUNCTION 1 pgroonga.typeof(oid, integer), FUNCTION 2 pgroonga.get_bpchar(internal, internal, bpchar); -------------- next part -------------- HTML����������������������������...Download