Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Patric Michael: "Thank you for a wonderful product, and all the hard work you've obviously taken".
J Canepa: "There is a lot of software out there for managing PostgreSQL. Yours is simply the best! Great product".

More

Add your opinion

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