CREATE OPERATOR CLASS

PostgreSQL 7.3.4 ��ե��󥹥ޥ˥奢��
Prev		Next

Synopsis

CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING access_method AS
  {  OPERATOR strategy_number operator_id [ ( type, type ) ] [ RECHECK ]
   | FUNCTION support_number func_name ( parameter_types )
   | STORAGE storage_type
  } [, ... ]

��

name: ��黻�ҥ��饹��̾��Ǥ�� 黻�ҥ��饹̾�ϡ��޽��̾�ˤǤ��ޤ��
DEFAULT: DEFAULT ��դ��ȡ��α黻�ҥ��饹��ǡ��Υǥե��ȤΥ��ǥå��黻�ҥ��饹�ˤʤ�ޤ�� Υǡ��ӥ��᥽�åɤΥǥե��ȤˤǤ��Τϡ�1 �Ĥα黻�ҥ��饹�ΤߤǤ��
data_type: ��α黻�ҥ��饹��Ѥ��Υǡ��Ǥ��
access_method: ��α黻�ҥ��饹��Ѥ��륤��ǥå��᥽�åɤ�̾��Ǥ��
strategy_number: �黻�ҥ��饹�˴�Ϣ��黻�ҤΥ��ǥå��᥽�åɤ��ά�ֹ�Ǥ��
operator_id: �黻�ҥ��饹�˴�Ϣ��黻�Ҥμ��̻ҤǤ� (��ץ��ǥ��޽��뤳�Ȥ��Ǥ��ޤ�)��
type: �黻�Ҥ��ϥǡ��⤷��ϡ��ñ��黻�Ҥ��ñ��黻�Ҥ�ɽ�� NONE ��ꤷ�ޤ�� ϥǡ��ϡ��黻�ҥ��饹�Υǡ��Ʊ��Ǥ��̾�ξ��ˤϡ��ά�Ǥ��ޤ��
RECHECK: RECHECK ��դ��ȡ��ǥå��黻�Ҥ��Ф��ơ�»��¿��׾��֤Ǥ��뤳�Ȥ򼨤��ޤ��äơ��ǥå��Ѥ��Ф��줿��ץ뤬��α黻�Ҥ�ޤ��ºݤ��Ƥ��뤫�򸡾ڤ��뤿��ˡ��Υ��ץ��٥��å��ɬ�פ��ޤ��
support_number: �黻�ҥ��饹�˴�Ϣ��ؿ��Υ��ǥå��᥽�åɤΥ��ݡ��ȥץ��ֹ�Ǥ��
func_name: �黻�ҥ��饹�Υ��ǥå��᥽�åɤΥ��ݡ��ȥץ��Ǥ��ؿ��̾��Ǥ� (��޽��̾�Ǥ��)��
parameter_types: �ؿ��Υѥ�᡼��Υǡ��Ǥ��
storage_type: ��ǥå��˼ºݤ˳�Ǽ��ǡ��Ǥ�� ̾��Υǡ��Υǡ��Ʊ��Ǥ��ۤʤ�ǡ��ǥå��᥽�åɤ⤢��ޤ� (��ɮ��ˤ� GIST �Τ�)�� STORAGE ��ϡ��ǥå��᥽�åɤǰۤʤ�ǡ��λ��Ѥ��Ĥ��Ƥ��ʤ��С��ά��ɬ�פ��ޤ��

��

CREATE OPERATOR CLASS: �黻�ҥ��饹�κ��֤��å��Ǥ��

��

CREATE OPERATOR CLASS ��¹Ԥ��ȡ��黻�ҥ��饹�Ǥ�� name ��Ǥ��ޤ��

�黻�ҥ��饹�ˤ�ꡢ��Υǡ��ǥå��ǤɤΤ褦�˻��Ѥ��뤫��ޤ�� 黻�ҥ��饹�ˤ�ꡢ��Υǡ��ӥ��᥽�åɤ��Υ��⤷��ϡ��ά�פˡ��ɤα黻�Ҥ��Ѥ��뤫��ꤵ��ޤ�� ޤ��黻�ҥ��饹�ˤ�ꡢ��ǥå��˱黻�ҥ��饹��򤹤�ݡ��ǥå��᥽�åɤǻ��Ѥ��륵�ݡ��ȥץ��㤬��ꤵ��ޤ�� 黻�ҥ��饹�ǻ��Ѥ��뤹�٤Ƥα黻�Ҥ��Ӵؿ��ϡ��黻�ҥ��饹��Ƥ��ɬ�פ��ޤ��

��̾��Ϳ��Ƥ��硢��α黻�ҥ��饹�ϻ��ꤵ�줿��ޤǺ��ޤ�� ̾��ʤ��С��黻�ҥ��饹�ϸ��ߤΥ�� (��ѥ��ˤ��륹��ޡ�CURRENT_SCHEMA() ��) �Ǻ��ޤ�� ۤʤ륤��ǥå��᥽�åɤ˻��Ѥ��ˤϡ�Ʊ�� 2 �Ĥα黻�ҥ��饹��Ʊ��̾��դ��뤳�Ȥ��Ǥ��ޤ��

�黻�ҥ��饹��桼��ν�ͭ�ԤȤʤ�ޤ�� ߡ��黻�ҥ��饹��桼��ϡ��ѡ��桼��Ǥ��ɬ�פ��ޤ�� (��ä��黻�ҥ��饹��ȡ��θ��Ȥʤꡢ��Х��å��θ��Ȥ��ʤ��뤿�ᡢ��¤��դ��Ƥ��ޤ��)

��ߡ�CREATE OPERATOR CLASS �Ǥϡ��ǥå��᥽�åɤ�ɬ�פʤ��٤Ƥα黻�Ҥ��Ӵؿ��饹��˴ޤޤ�Ƥ��뤫�ɤ��å��ޤ�� 桼��Ǥ�ˤ��ơ�ͭ��ʱ黻�ҥ��饹��Ƥ��

�ܺ٤ˤĤ��Ƥϡ�PostgreSQL �ץ��ޥ���Ρ֥��ǥå��ĥ��ǽ�ؤΥ��󥿥ե��פξϤ򻲾Ȥ��Ƥ��

��

�桼��α黻�ҥ��饹��ǡ��١��ϡ�DROP OPERATOR CLASS �򻲾Ȥ��Ƥ��

��ˡ

�ʲ��Υ��ޥ��Ǥϡ��ǡ�� _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);

OPERATOR��FUNCTION�� STORAGE ��ν��ϡ��ѹ��ǽ�Ǥ��

CREATE OPERATOR CLASS

Name

Synopsis

��

��

��

��

��ˡ

�ߴ��

SQL92

CREATE OPERATOR CLASS

Name

Synopsis

����

����

����

����

������ˡ

�ߴ���

SQL92

��

��

��

��

��ˡ

�ߴ��