Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Operator Class
 

The operator class identifies the operators to be used by the index for that column. For example, a B-tree index on the type int4 would use the int4_ops class; this operator class includes comparison functions for values of type int4.

Create a Operator Class

To create a operator class :

  1. Select the Database in the Tree View and select Others > Operator Class from the toolbar
  2. Press the New Operator Class button
  3. Enter Operator Class properties and fields on the appropriate tabs of the New Operator Class Editor
  4. Click OK

Design a Operator Class

To design a operator class:

  1. Select the Database in the Tree View and select Others > Operator Class from the toolbar
  2. Select the operator class you want to design.
  3. Press the Design Operator Class button.
  4. Edit Operator Class properties and fields on the appropriate tabs of the Design Operator Class Editor
  5. Click OK

Delete a Operator Class

To delete a operator class:

  1. Select the Database in the Tree View and select Others > Operator Class from the toolbar
  2. Select the operator class you want to delete.
  3. Click the Delete Operator Class button.
  4. Confirm deleting in the dialog window.