CREATE OPERATOR CLASS
目录
CREATE OPERATOR CLASS
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
CREATE OPERATOR CLASS - å®ä¹ä¸ä¸ªæ°çæä½ç¬¦ç±»
SYNOPSIS
CREATE OPERATOR
CLASS name [ DEFAULT ] FOR TYPE data_type
USING index_method AS
{ OPERATOR strategy_number operator_name [ (
op_type, op_type ) ] [ RECHECK ]
| FUNCTION support_number funcname (
argument_type [, ...] )
| STORAGE storage_type
} [, ... ]
DESCRIPTION æè¿°
CREATE OPERATOR CLASS å®ä¹ä¸ä¸ªæ°çæä½ç¬¦è¡¨ã ä¸ä¸ªæä½ç¬¦è¡¨å®ä¹ä¸ç§ç¹å®çæ°æ®ç±»åå¯ä»¥å¦ä½ä¸ä¸ç§ç´¢å¼ä¸èµ·ä½¿ç¨ã æä½ç¬¦è¡¨å£°æç¹å®çæä½ç¬¦å¯ä»¥ä¸ºè¿ç§æ°æ®ç±»å以åè¿ç§ç´¢å¼æ¹æ³å¡«åç¹å®è§è²æè"ç- ç¥"ã æä½ç¬¦è¡¨è¿å£°æç´¢å¼æ¹æ³å¨ä¸ºä¸ä¸ªç´¢å¼å- 段éå®è¯¥æä½ç¬¦è¡¨çæ¶åè¦ä½¿ç¨çæ¯æè¿ç¨ã æææä½ç¬¦è¡¨ä½¿ç¨çå½æ°åæä½ç¬¦é½å¿é¡»å¨å建æä½ç¬¦è¡¨ä¹åå®ä¹ã
å¦æç»åºäºæ¨¡å¼ååï¼é£ä¹æä½ç¬¦è¡¨å°±å¨æå®ç模å¼ä¸å建ã å¦åå°±å¨å½å模å¼ä¸å建ï¼å¨æ索路å¾åé¢çé£ä¸ªï¼åé CURRENT_SCHEMA()ï¼ã å¨åä¸ä¸ªæ¨¡å¼ä¸ç两个æä½ç¬¦è¡¨å¯ä»¥æåæ ·çåå- ï¼ä½å®ä»¬å¿é¡»ç¨äºä¸åçç´¢å¼æ¹æ³ã
å®ä¹æä½ç¬¦è¡¨çç¨æ·æ为å¶ææèãç®åï¼åé èå¿é¡»æ¯è¶çº§ç¨æ·ã ï¼ä½è¿æ ·çéå¶æ¯å 为ä¸ä¸ªæé®é¢çæä½ç¬¦è¡¨å®ä¹ä¼è®©æå¡å¨å°æï¼çè³å´©æºãï¼
CREATE OPERATOR CLASS ç®å并ä¸æ£æ¥è¿ä¸ªç±»å®ä¹æ¯å¦åå«ææç´¢å¼æ¹æ³éè¦æä½ç¬¦ä»¥åå½æ°ã å®ä¹ä¸ä¸ªåæ³çæä½ç¬¦è¡¨æ¯ç¨æ·ç责任ã
åè ‘‘Interfacing Extensions to Indexes’’ è·åæ´å¤ä¿¡æ¯ã
PARAMETERS åæ°
|
name |
å°è¦å建çæä½ç¬¦è¡¨çååãååå¯ä»¥ç¨æ¨¡å¼ä¿®é¥°ã
DEFAULT
å¦æåºç°äºè¿ä¸ªé®å- ï¼é£ä¹è¯¥æä½ç¬¦è¡¨å°æ为å®çæ°æ®ç±»åç缺çæä½ç¬¦è¡¨ã 对äºæ个æ°æ®ç±»åå访é®æ¹å¼èè¨ï¼æå¤å¯ä»¥æä¸ä¸ªæä½ç¬¦è¡¨æ¯ç¼ºççã
data_type
è¿ä¸ªæä½ç¬¦è¡¨å¤ççå段æ°æ®ç±»åã
index_method
è¿ä¸ªæä½ç¬¦è¡¨å¤ççç´¢å¼è®¿é®æ¹å¼çååã
strategy_number
ä¸ä¸ªæä½ç¬¦åè¿ä¸ªæä½ç¬¦è¡¨å³èçç´¢å¼è®¿é®æ¹å¼ççç¥æ°ã
operator_name
ä¸ä¸ªå该æä½ç¬¦è¡¨å³èçæä½ç¬¦çååï¼å¯ä»¥ç¨æ¨¡å¼ä¿®é¥°ï¼ã
op_type
ä¸ä¸ªæä½ç¬¦çè¾å¥æ°æ®ç±»åï¼æèæ¯ NONE 表示左ç®æèå³ç®æä½ç¬¦ã é常æåµä¸å¯ä»¥çç¥è¾å¥æ°æ®ç±»åï¼å为è¿ä¸ªæ¶åå®ä»¬åæä½ç¬¦è¡¨çæ°æ®ç±»åç¸åã
RECHECK
å¦æåºç°ï¼é£ä¹ç´¢å¼å¯¹è¿ä¸ªæä½ç¬¦æ¯"lossy"ï¼ææèçï¼ï¼ å æ- ¤ï¼ä½¿ç¨è¿ä¸ªç´¢å¼æ£ç´¢çè¡å¿é¡»éæ°æ£æ¥ï¼ä»¥ä¿è¯å®ä»¬çæ£æ»¡è¶³åæ- ¤æä½ç¬¦ç¸å³çæ¡ä»¶åå¥ã
support_number
ç´¢å¼æ¹æ³å¯¹ä¸ä¸ªä¸æä½ç¬¦è¡¨å³èçå½æ°çæ¯æè¿ç¨æ°ã
funcname
ä¸ä¸ªå½æ°çåå- ï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ï¼è¿ä¸ªå½æ°æ¯ç´¢å¼è®¿é®æ¹å¼å¯¹æ- ¤æä½ç¬¦è¡¨çæ¯æè¿ç¨ã
argument_types
å½æ°çåæ°æ°æ®ç±»åã
storage_type
å®éåå¨å¨ç´¢å¼éçæ°æ®ç±»åãé常å®åå段æ°æ®ç±»åç¸åï¼ ä½æ¯ä¸äºç´¢å¼æ¹æ³ï¼å°ç®å为æ¢åªæ GISTï¼å许å®æ¯ä¸åçã é¤éç´¢å¼æ¹æ³å许使ç¨ä¸ç§ä¸åçç±»åï¼å¦åå¿é¡»çç¥ STORAGE åå¥ã
OPERATORï¼FUNCTIONï¼å STORAGE åå¥å¯ä»¥æç§ä»»æ顺åºåºç°ã
EXAMPLES ä¾å
ä¸é¢çä¾åå½ä»¤ä¸ºæ°æ®ç±»å _int4ï¼int4 çæ°ç»ï¼å®ä¹äºä¸ä¸ª GiST ç´¢å¼æä½ç¬¦è¡¨ã åé contrib/intarray/ è·åå®æ´çä¾åã
CREATE OPERATOR
CLASS gist__int_ops
DEFAULT FOR TYPE _int4 USING gist AS
OPERATOR 3 &&,
OPERATOR 6 = RECHECK,
OPERATOR 7 @,
OPERATOR 8 ˜,
OPERATOR 20 @@ (_int4, query_int),
FUNCTION 1 g_int_consistent (internal, _int4, int4),
FUNCTION 2 g_int_union (bytea, internal),
FUNCTION 3 g_int_compress (internal),
FUNCTION 4 g_int_decompress (internal),
FUNCTION 5 g_int_penalty (internal, internal, internal),
FUNCTION 6 g_int_picksplit (internal, internal),
FUNCTION 7 g_int_same (_int4, _int4, internal);
COMPATIBILITY å¼å®¹æ§
CREATE OPERATOR CLASS æ¯ä¸ä¸ª PostgreSQL æ©å±ã å¨ SQL æ åä¸æ²¡æ CREATE OPERATOR CLASSã
SEE ALSO åè§
ALTER OPERATOR CLASS [alter_operator_class(7)], DROP OPERATOR CLASS [drop_operator_class(l)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh