Operator class: poly

Properties

Name:	poly_ops
OID:	2594
Owner:	postgres
Default:
For type:	polygon
Access method:	gist
Storage:	box
Comment:
Operator:	1 <<(polygon,polygon)
Operator:	2 &<(polygon,polygon)
Operator:	3 &&(polygon,polygon)
Operator:	4 &>(polygon,polygon)
Function:	gist_poly_consistent(internal, polygon, integer)
Function:	gist_box_union(internal, internal)
Function:	gist_poly_compress(internal)
Function:	gist_box_decompress(internal)

SQL

CREATE OPERATOR CLASS poly_ops
    DEFAULT FOR TYPE polygon USING gist AS
    STORAGE box ,
    OPERATOR 1 <<(polygon,polygon) RECHECK ,
    OPERATOR 2 &<(polygon,polygon) RECHECK ,
    OPERATOR 3 &&(polygon,polygon) RECHECK ,
    OPERATOR 4 &>(polygon,polygon) RECHECK ,
    OPERATOR 5 >>(polygon,polygon) RECHECK ,
    OPERATOR 6 ~=(polygon,polygon) RECHECK ,
    OPERATOR 7 @>(polygon,polygon) RECHECK ,
    OPERATOR 8 <@(polygon,polygon) RECHECK ,
    OPERATOR 9 &<|(polygon,polygon) RECHECK ,
    OPERATOR 10 <<|(polygon,polygon) RECHECK ,
    OPERATOR 11 |>>(polygon,polygon) RECHECK ,
    OPERATOR 12 |&>(polygon,polygon) RECHECK ,
    OPERATOR 13 ~(polygon,polygon) RECHECK ,
    OPERATOR 14 @(polygon,polygon) RECHECK ,
    FUNCTION 1 gist_poly_consistent(internal,polygon,integer) ,
    FUNCTION 2 gist_box_union(internal,internal) ,
    FUNCTION 3 gist_poly_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.poly_ops USING gist OWNER TO postgres;