Operator

User defined comparison operator

Properties

Property	Type	Required	Description
name	string	—	The name of the operator function to create.
schema	string	—	The schema to create the operator function in.
owner	string	—	The role that owns the operator function.
sql	string	—	User-provided raw SQL snippet.
function	string	—	The function used to implement this operator.
left_arg	string	—	The data type of the operator's left operand, if any. This option would be omitted for a left-unary operator.
right_arg	string	—	The data type of the operator's right operand, if any. This option would be omitted for a right-unary operator.
commutator	string	—	The commutator of this operator.
negator	string	—	The negator of this operator.
restrict	string	—	The restriction selectivity estimator function for this operator.
join	string	—	The join selectivity estimator function for this operator.
hashes	boolean	—	Indicates this operator can support a hash join.
merges	boolean	—	Indicates this operator can support a merge join.
comment	string	—	An optional comment about the operator.
dependencies	dependencies	—	Database objects this object is dependent upon.

Mutually exclusive forms

Exactly one of these must hold:

• sql, without function or left_arg or right_arg or commutator or negator or restrict or join or hashes or merges or sql
• function, without sql

---

Source: schemata/operator.yml · Resolved JSON Schema: operator.json