Postgres Pro
Downloads
Home   >   mailing lists

Re: Custom Operators Cannot be Found for Composite Type Values - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Custom Operators Cannot be Found for Composite Type Values
Date
Msg-id 27277.1331234193@sss.pgh.pa.us
Whole thread Raw
In response to Re: Custom Operators Cannot be Found for Composite Type Values  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: Custom Operators Cannot be Found for Composite Type Values
Re: Custom Operators Cannot be Found for Composite Type Values
List pgsql-hackers
Tree view 
"David E. Wheeler" <david@justatheory.com> writes:
>     CREATE OPERATOR CLASS json_ops
>     DEFAULT FOR TYPE JSON USING btree AS
>     OPERATOR    3   =  (json, json),
>     FUNCTION    1   json_cmp(json, json);

> This seems to work.

Urk.  You really ought to provide the whole opclass (all 5 operators).
I'm not sure what will blow up if you leave it like that, but it won't
be pretty.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Custom Operators Cannot be Found for Composite Type Values
Next
From: Noah Misch
Date:
Subject: Re: Collect frequency statistics for arrays