DROP OPERATOR CLASS

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

---

NAME

DROP OPERATOR CLASS - å é¤ä¸ä¸ªæä½ç¬¦ç±»

SYNOPSIS

DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]

DESCRIPTION æè¿°

DROP OPERATOR CLASS ä»æ°æ®åºä¸- å é¤ä¸ä¸ªç°ææä½ç¬¦è¡¨ãè¦æ§è¡è¿æ¡å½ä»¤ï¼ä½ å¿é¡»æ¯æ¤æä½ç¬¦è¡¨çææèã

PARAMETERS åæ°

name

ä¸ä¸ªç°åæä½ç¬¦è¡¨çååï¼å¯ä»¥ç¨æ¨¡å¼ä¿®é¥°ï¼ã

index_method

æä½ç¬¦è¡¨æ对ä»çç´¢å¼è®¿é®æ¹æ³çååã

CASCADE

èªå¨å é¤ä¾èµäºè¯¥æä½ç¬¦è¡¨ç对象ã

RESTRICT

å¦ææä»»ä½ä¾èµå¯¹è±¡åå¨ï¼åæç»å é¤æ¤æä½ç¬¦è¡¨ãè¿ä¸ªè¡ä¸ºæ¯ç¼ºçã

EXAMPLES ä¾å

å é¤ B-tree æä½ç¬¦è¡¨ widget_opsï¼

DROP OPERATOR CLASS widget_ops USING btree;

å¦ææä»»ä½ç°åçç´¢å¼ä½¿ç¨è¿ä¸ªæä½ç¬¦è¡¨ï¼é£ä¹è¿æ¡å½ä»¤å°ä¸è½ æ§è¡ãå¢å ä¸ä¸ª CASCADE å é¤è¿æ ·çç´¢å¼ä»¥åè¿ä¸ª æä½ç¬¦è¡¨ã

COMPATIBILITY å¼å®¹æ§

å¨ SQL æ åé没æ DROP OPERATOR CLASSã

SEE ALSO åè§

ALTER OPERATOR CLASS [alter_operator_class(7)], CREATE OPERATOR CLASS [create_operator_class(l)]

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---