What are the categories of the Navicat for PostgreSQL operator

Source: Internet
Author: User
Tags postgresql postgresql function postgresql version

The Navicat for PostgreSQL operator category defines the specific data type that is used with the index, and the operator category specifies that some operators will fill a specific role or "policy" for the data type and index method, and also specify the procedure used by the index method when the operator category is selected to the indexed column. All operator categories must be defined before they are created, and a list of operator category objects is opened by clicking on the other operator categories on the Navicat main interface.


Navicat for PostgreSQL

Tip: Only if the two operator classes are different index methods can they have the same name in the same pattern. The Notes tab is supported for PostgreSQL 8.0 or later.

Navicat for PostgreSQL operator category General properties

Owner: Owner of the operator category function that supports PostgreSQL 8.0 or later.

Schema and data type of the data type: The column data type of the operator category.

Index method: The name of the index method for the operator category.

The mode and storage type of the storage type: The data type is actually saved in the index, usually the same as the column data type, but some index methods (now GIN and GiST) allow it to be different. The STORAGE clause must be omitted unless the indexed method allows different types to be used.

Operator family: The existing operator family name adds an operator category. If not specified, the family naming and operator categories are used (if not present, can be created) to support PostgreSQL 8.3 or later.

Default operator Category: Tick this, the operator category becomes the default operator category, up to the default one operator category.

Navicat for PostgreSQL operator

Policy number: The policy number of the operator index method.

Operator's schema and operator name: operators related to the operator category.

Recheck: Tick This, the index of the operator is "lossy", and all retrieved rows must be re-examined to verify that they actually conform to the restriction clause of this operator.

Warm tip: The OPERATOR clause may include the recheck option before PostgreSQL version 8.4. The new version is no longer supported, because whether an index operator is "lossy" is determined during runtime.

Navicat for PostgreSQL function

Support Number: The index method supports the procedure number.

function's schema and function name: The function that the index method supports the procedure.

For more tutorials on Navicat for PostgreSQL, refer to the Navicat website .

The above is reproduced content, the original is: http://www.formysql.com/wenti/yunsuanfu-leibie.html

What are the categories of the Navicat for PostgreSQL operator

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.