PostgreSQL Maestro online Help
Prev | Return to chapter overview | Next |
Editing operator proprties
Operator Editor provides you with an ability to edit operator properties. The Properties tab allows you to change the operator name, the operator owner and the comment for the operator. You can also find the OID there.
Name
Here you can change the operator name.
Owner
Here you can change the operator owner. By default, only the owner of an object can perform various operations with the object. In order to allow other users to operate it, privileges must be granted. (However, users that have the superuser attribute can always access any object.)
Comment
This field stores a comment to the operator.
OID
The field stores the operator OID (object identifier).
Function
The function used to implement this operator is supplied in this box.
Left operand type
Edit the data type of the operator left operand, if any. This option can be omitted for a left-unary operator.
Right operand type
Edit the data type of the operator right operand, if any. This option can be omitted for a right-unary operator.
Commutator
Specify the commutator of the operator.
Negator
Set the negator of the operator.
Restrict Function
Specify the restriction selectivity estimator function for the operator.
Join Function
The join selectivity estimator function for this operator.
Left Sort Operator
If the operator can support a merge join, the less-than operator that sorts the left-hand data type of this operator.
Right Sort Operator
If the operator can support a merge join, the less-than operator that sorts the right-hand data type of this operator.
Less Than Operator
If the operator can support a merge join, the less-than operator that compares the input data types of this operator.
Greater Than Operator
If the operator can support a merge join, the greater-than operator that compares the input data types of this operator.
The Supports Hash Joins and Supports Merge Joins checkboxes are meant to indicate that this operator can support a hash join and a merge join respectively.
To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.
It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.
Prev | Return to chapter overview | Next |