Properties

Name: circle_ops 
OID: 2595 
Owner: postgres 
Default:  
For type: circle 
Access method: gist 
Storage: box 
Comment:  
Operator: 1 <<(circle,circle) 
Operator: 2 &<(circle,circle) 
Operator: 3 &&(circle,circle) 
Operator: 4 &>(circle,circle) 
Function: gist_circle_consistent(internal, circle, integer) 
Function: gist_box_union(internal, internal) 
Function: gist_circle_compress(internal) 
Function: gist_box_decompress(internal) 

SQL


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

See Also

List of operator classes