Comunitatea PHP Romania
 

 
pg_operator

43.25. pg_operator

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

Table 43-25. pg_operator Columns

NameTypeReferencesDescription
oprnamename Name of the operator
oprnamespaceoidpg_namespace.oid The OID of the namespace that contains this operator
oprowneroidpg_authid.oidOwner of the operator
oprkindchar  b = infix ("both"), l = prefix ("left"), r = postfix ("right")
oprcanhashbool This operator supports hash joins
oprleftoidpg_type.oidType of the left operand
oprrightoidpg_type.oidType of the right operand
oprresultoidpg_type.oidType of the result
oprcomoidpg_operator.oidCommutator of this operator, if any
oprnegateoidpg_operator.oidNegator of this operator, if any
oprlsortopoidpg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L)
oprrsortopoidpg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R)
oprltcmpopoidpg_operator.oid If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R)
oprgtcmpopoidpg_operator.oid If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R)
oprcoderegprocpg_proc.oidFunction that implements this operator
oprrestregprocpg_proc.oidRestriction selectivity estimation function for this operator
oprjoinregprocpg_proc.oidJoin selectivity estimation function for this operator

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

Ultimele discutii in forum RSS Forum

Ultimele articole Ultimele articole

Top membri

Pirahna Pirahna
la birou
carco carco
Bucuresti
Birkoff Birkoff
Bucuresti
Mascka Mascka
Braila
raul_ raul_
whooper whooper
Toronto ON
mihaitha mihaitha
Sibiu
gabysolomon gabysolomon
Bacau
oriceon oriceon
Constanta
garlicinicolae garlicinicolae

Newsletter


Email:
 inscriere
 renuntare
 
 Arhiva newsletter

Parteneriat

Copyright © 2001-2008 PHP Romania Add PHPRomania to Google Add PHPRomania to Del.icio.us Add PHPRomania to Stumbleupon Add PHPRomania to Yahoo! Add PHPRomania to Digg Add PHPRomania to Blink iPhone Reviews | MPAA | Car Loan | Loans | Free Advertising
Ads: Partener Way2Web Nework: gazduire web | inregistrare domenii | web design | imobiliare | web hosting
Powered by Simplis