Free Webmaster Tools and Resources

W3-Tools.com

Search Engine Optimization Domain Names Webmasters Web design

Webmaster Forum Webmaster News Links Directory

Search Engine Spider Simulator Keyword Analyser Tool Keywords Generator

Domain Tools

Domain Name Checker Whois Domain Lookup Domain Typo Generator

Web Utilities

HTTP Header Viewer Link Extractor Mime Types List

HTML Tools

Websafe Color Tool HTML Entity Chart

Documentation

PHP Manual PEAR Manual Smarty Manual PHP-GTK Manual Apache Manual MySQL Manual PostgreSQL Manual

PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL 8.1.3 Documentation
Prev	Fast Backward	Chapter 42. System Catalogs	Fast Forward	Next

42.25. `pg_operator`

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 32.12 for more information.

Table 42-25. pg_operator Columns

Name	Type	References	Description
`oprname`	`name`		Name of the operator
`oprnamespace`	`oid`	`pg_namespace.oid`	The OID of the namespace that contains this operator
`oprowner`	`oid`	`pg_authid.oid`	Owner of the operator
`oprkind`	`char`		`b` = infix ("both"), `l` = prefix ("left"), `r` = postfix ("right")
`oprcanhash`	`bool`		This operator supports hash joins
`oprleft`	`oid`	`pg_type.oid`	Type of the left operand
`oprright`	`oid`	`pg_type.oid`	Type of the right operand
`oprresult`	`oid`	`pg_type.oid`	Type of the result
`oprcom`	`oid`	`pg_operator.oid`	Commutator of this operator, if any
`oprnegate`	`oid`	`pg_operator.oid`	Negator of this operator, if any
`oprlsortop`	`oid`	`pg_operator.oid`	If this operator supports merge joins, the operator that sorts the type of the left-hand operand (`L<L`)
`oprrsortop`	`oid`	`pg_operator.oid`	If this operator supports merge joins, the operator that sorts the type of the right-hand operand (`R<R`)
`oprltcmpop`	`oid`	`pg_operator.oid`	If this operator supports merge joins, the less-than operator that compares the left and right operand types (`L<R`)
`oprgtcmpop`	`oid`	`pg_operator.oid`	If this operator supports merge joins, the greater-than operator that compares the left and right operand types (`L>R`)
`oprcode`	`regproc`	`pg_proc.oid`	Function that implements this operator
`oprrest`	`regproc`	`pg_proc.oid`	Restriction selectivity estimation function for this operator
`oprjoin`	`regproc`	`pg_proc.oid`	Join selectivity estimation function for this operator

Unused column contain zeroes, for example oprleft is zero for a prefix operator.

Prev	Home	Next
`pg_opclass`	Up	`pg_pltemplate`

Newsletter

Join to our newsletter and receive news and updates about our site.
Your name:
E-mail address:
Action:

Hosted by

Search

			Links

Copyright © 2006. by w3-tools.com. All rights reserved