Operator class: box

Properties

Name:	box_ops
OID:	2593
Owner:	postgres
Default:
For type:	box
Access method:	gist
Storage:
Comment:
Operator:	1 <<(box,box)
Operator:	2 &<(box,box)
Operator:	3 &&(box,box)
Operator:	4 &>(box,box)
Function:	gist_box_consistent(internal, box, integer)
Function:	gist_box_union(internal, internal)
Function:	gist_box_compress(internal)
Function:	gist_box_decompress(internal)

SQL

CREATE OPERATOR CLASS box_ops
    DEFAULT FOR TYPE box USING gist AS
    OPERATOR 1 <<(box,box) ,
    OPERATOR 2 &<(box,box) ,
    OPERATOR 3 &&(box,box) ,
    OPERATOR 4 &>(box,box) ,
    OPERATOR 5 >>(box,box) ,
    OPERATOR 6 ~=(box,box) ,
    OPERATOR 7 @>(box,box) ,
    OPERATOR 8 <@(box,box) ,
    OPERATOR 9 &<|(box,box) ,
    OPERATOR 10 <<|(box,box) ,
    OPERATOR 11 |>>(box,box) ,
    OPERATOR 12 |&>(box,box) ,
    OPERATOR 13 ~(box,box) ,
    OPERATOR 14 @(box,box) ,
    FUNCTION 1 gist_box_consistent(internal,box,integer) ,
    FUNCTION 2 gist_box_union(internal,internal) ,
    FUNCTION 3 gist_box_compress(internal) ,
    FUNCTION 4 gist_box_decompress(internal) ,
    FUNCTION 5 gist_box_penalty(internal,internal,internal) ,
    FUNCTION 6 gist_box_picksplit(internal,internal) ,
    FUNCTION 7 gist_box_same(box,box,internal);

ALTER OPERATOR CLASS pg_catalog.box_ops USING gist OWNER TO postgres;