create_operator_family(7) - phpMan

CREATE OPERATOR FAMILY()                   SQL Commands                  CREATE OPERATOR FAMILY()



NAME
       CREATE OPERATOR FAMILY - define a new operator family


SYNOPSIS
       CREATE OPERATOR FAMILY name USING index_method


DESCRIPTION
       CREATE  OPERATOR  FAMILY creates a new operator family.  An operator family defines a col-
       lection of related operator classes, and perhaps some  additional  operators  and  support
       functions  that are compatible with these operator classes but not essential for the func-
       tioning of any individual index. (Operators and functions that are  essential  to  indexes
       should  be  grouped within the relevant operator class, rather than being ``loose'' in the
       operator family.  Typically, single-data-type operators are  bound  to  operator  classes,
       while  cross-data-type  operators  can  be loose in an operator family containing operator
       classes for both data types.)

       The new operator family is initially empty. It should be populated by  issuing  subsequent
       CREATE  OPERATOR  CLASS  commands  to add contained operator classes, and optionally ALTER
       OPERATOR FAMILY commands to add ``loose'' operators and their corresponding support  func-
       tions.

       If  a  schema  name  is given then the operator family is created in the specified schema.
       Otherwise it is created in the current schema.  Two operator families in the  same  schema
       can have the same name only if they are for different index methods.

       The  user  who  defines an operator family becomes its owner. Presently, the creating user
       must be a superuser. (This restriction is made because an erroneous operator family  defi-
       nition could confuse or even crash the server.)

       Refer to in the documentation for further information.

PARAMETERS
       name   The name of the operator family to be created. The name can be schema-qualified.

       index_method
              The name of the index method this operator family is for.

COMPATIBILITY
       CREATE  OPERATOR  FAMILY  is  a  PostgreSQL  extension. There is no CREATE OPERATOR FAMILY
       statement in the SQL standard.

SEE ALSO
       ALTER OPERATOR FAMILY [alter_operator_family(7)], DROP OPERATOR FAMILY [drop_operator_fam-
       ily(l)],   CREATE   OPERATOR   CLASS   [create_operator_class(l)],  ALTER  OPERATOR  CLASS
       [alter_operator_class(l)], DROP OPERATOR CLASS [drop_operator_class(l)]



SQL - Language Statements                   2011-09-22                   CREATE OPERATOR FAMILY()

Generated by $Id: phpMan.php,v 4.49 2006/02/26 13:18:18 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2012-05-25 15:30 @38.107.179.237 Crawled by CCBot/1.0 (+http://www.commoncrawl.org/bot.html)