I386LINUX/util/I386LINUX/doc/postgresql/html/catalog-pg-operator.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >pg_operator</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="System Catalogs"
  16 HREF="catalogs.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="pg_opclass"
  19 HREF="catalog-pg-opclass.html"><LINK
  20 REL="NEXT"
  21 TITLE="pg_proc"
  22 HREF="catalog-pg-proc.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="catalog-pg-opclass.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="catalogs.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 43. System Catalogs</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="catalogs.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="catalog-pg-proc.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="CATALOG-PG-OPERATOR"
  96 >43.23. <TT
  97 CLASS="STRUCTNAME"
  98 >pg_operator</TT
  99 ></A
 100 ></H1
 101 ><A
 102 NAME="AEN50760"
 103 ></A
 104 ><P
 105 >   The catalog <TT
 106 CLASS="STRUCTNAME"
 107 >pg_operator</TT
 108 > stores information about operators.  See
 109    <TT
 110 CLASS="COMMAND"
 111 >CREATE OPERATOR</TT
 112 > and <A
 113 HREF="xoper.html"
 114 >Section 33.11</A
 115 > for
 116    details on these operator parameters.
 117   </P
 118 ><DIV
 119 CLASS="TABLE"
 120 ><A
 121 NAME="AEN50766"
 122 ></A
 123 ><P
 124 ><B
 125 >Table 43-23. <TT
 126 CLASS="STRUCTNAME"
 127 >pg_operator</TT
 128 > Columns</B
 129 ></P
 130 ><TABLE
 131 BORDER="1"
 132 CLASS="CALSTABLE"
 133 ><COL><COL><COL><COL><THEAD
 134 ><TR
 135 ><TH
 136 >Name</TH
 137 ><TH
 138 >Type</TH
 139 ><TH
 140 >References</TH
 141 ><TH
 142 >Description</TH
 143 ></TR
 144 ></THEAD
 145 ><TBODY
 146 ><TR
 147 ><TD
 148 ><TT
 149 CLASS="STRUCTFIELD"
 150 >oprname</TT
 151 ></TD
 152 ><TD
 153 ><TT
 154 CLASS="TYPE"
 155 >name</TT
 156 ></TD
 157 ><TD
 158 >&nbsp;</TD
 159 ><TD
 160 >Name of the operator</TD
 161 ></TR
 162 ><TR
 163 ><TD
 164 ><TT
 165 CLASS="STRUCTFIELD"
 166 >oprnamespace</TT
 167 ></TD
 168 ><TD
 169 ><TT
 170 CLASS="TYPE"
 171 >oid</TT
 172 ></TD
 173 ><TD
 174 ><TT
 175 CLASS="LITERAL"
 176 ><A
 177 HREF="catalog-pg-namespace.html"
 178 ><TT
 179 CLASS="STRUCTNAME"
 180 >pg_namespace</TT
 181 ></A
 182 >.oid</TT
 183 ></TD
 184 ><TD
 185 >       The OID of the namespace that contains this operator
 186       </TD
 187 ></TR
 188 ><TR
 189 ><TD
 190 ><TT
 191 CLASS="STRUCTFIELD"
 192 >oprowner</TT
 193 ></TD
 194 ><TD
 195 ><TT
 196 CLASS="TYPE"
 197 >int4</TT
 198 ></TD
 199 ><TD
 200 ><TT
 201 CLASS="LITERAL"
 202 ><A
 203 HREF="catalog-pg-shadow.html"
 204 ><TT
 205 CLASS="STRUCTNAME"
 206 >pg_shadow</TT
 207 ></A
 208 >.usesysid</TT
 209 ></TD
 210 ><TD
 211 >Owner of the operator</TD
 212 ></TR
 213 ><TR
 214 ><TD
 215 ><TT
 216 CLASS="STRUCTFIELD"
 217 >oprkind</TT
 218 ></TD
 219 ><TD
 220 ><TT
 221 CLASS="TYPE"
 222 >char</TT
 223 ></TD
 224 ><TD
 225 >&nbsp;</TD
 226 ><TD
 227 >       <TT
 228 CLASS="LITERAL"
 229 >b</TT
 230 > = infix (<SPAN
 231 CLASS="QUOTE"
 232 >"both"</SPAN
 233 >), <TT
 234 CLASS="LITERAL"
 235 >l</TT
 236 > = prefix
 237        (<SPAN
 238 CLASS="QUOTE"
 239 >"left"</SPAN
 240 >), <TT
 241 CLASS="LITERAL"
 242 >r</TT
 243 > = postfix (<SPAN
 244 CLASS="QUOTE"
 245 >"right"</SPAN
 246 >)
 247       </TD
 248 ></TR
 249 ><TR
 250 ><TD
 251 ><TT
 252 CLASS="STRUCTFIELD"
 253 >oprcanhash</TT
 254 ></TD
 255 ><TD
 256 ><TT
 257 CLASS="TYPE"
 258 >bool</TT
 259 ></TD
 260 ><TD
 261 >&nbsp;</TD
 262 ><TD
 263 >This operator supports hash joins</TD
 264 ></TR
 265 ><TR
 266 ><TD
 267 ><TT
 268 CLASS="STRUCTFIELD"
 269 >oprleft</TT
 270 ></TD
 271 ><TD
 272 ><TT
 273 CLASS="TYPE"
 274 >oid</TT
 275 ></TD
 276 ><TD
 277 ><TT
 278 CLASS="LITERAL"
 279 ><A
 280 HREF="catalog-pg-type.html"
 281 ><TT
 282 CLASS="STRUCTNAME"
 283 >pg_type</TT
 284 ></A
 285 >.oid</TT
 286 ></TD
 287 ><TD
 288 >Type of the left operand</TD
 289 ></TR
 290 ><TR
 291 ><TD
 292 ><TT
 293 CLASS="STRUCTFIELD"
 294 >oprright</TT
 295 ></TD
 296 ><TD
 297 ><TT
 298 CLASS="TYPE"
 299 >oid</TT
 300 ></TD
 301 ><TD
 302 ><TT
 303 CLASS="LITERAL"
 304 ><A
 305 HREF="catalog-pg-type.html"
 306 ><TT
 307 CLASS="STRUCTNAME"
 308 >pg_type</TT
 309 ></A
 310 >.oid</TT
 311 ></TD
 312 ><TD
 313 >Type of the right operand</TD
 314 ></TR
 315 ><TR
 316 ><TD
 317 ><TT
 318 CLASS="STRUCTFIELD"
 319 >oprresult</TT
 320 ></TD
 321 ><TD
 322 ><TT
 323 CLASS="TYPE"
 324 >oid</TT
 325 ></TD
 326 ><TD
 327 ><TT
 328 CLASS="LITERAL"
 329 ><A
 330 HREF="catalog-pg-type.html"
 331 ><TT
 332 CLASS="STRUCTNAME"
 333 >pg_type</TT
 334 ></A
 335 >.oid</TT
 336 ></TD
 337 ><TD
 338 >Type of the result</TD
 339 ></TR
 340 ><TR
 341 ><TD
 342 ><TT
 343 CLASS="STRUCTFIELD"
 344 >oprcom</TT
 345 ></TD
 346 ><TD
 347 ><TT
 348 CLASS="TYPE"
 349 >oid</TT
 350 ></TD
 351 ><TD
 352 ><TT
 353 CLASS="LITERAL"
 354 ><A
 355 HREF="catalog-pg-operator.html"
 356 ><TT
 357 CLASS="STRUCTNAME"
 358 >pg_operator</TT
 359 ></A
 360 >.oid</TT
 361 ></TD
 362 ><TD
 363 >Commutator of this operator, if any</TD
 364 ></TR
 365 ><TR
 366 ><TD
 367 ><TT
 368 CLASS="STRUCTFIELD"
 369 >oprnegate</TT
 370 ></TD
 371 ><TD
 372 ><TT
 373 CLASS="TYPE"
 374 >oid</TT
 375 ></TD
 376 ><TD
 377 ><TT
 378 CLASS="LITERAL"
 379 ><A
 380 HREF="catalog-pg-operator.html"
 381 ><TT
 382 CLASS="STRUCTNAME"
 383 >pg_operator</TT
 384 ></A
 385 >.oid</TT
 386 ></TD
 387 ><TD
 388 >Negator of this operator, if any</TD
 389 ></TR
 390 ><TR
 391 ><TD
 392 ><TT
 393 CLASS="STRUCTFIELD"
 394 >oprlsortop</TT
 395 ></TD
 396 ><TD
 397 ><TT
 398 CLASS="TYPE"
 399 >oid</TT
 400 ></TD
 401 ><TD
 402 ><TT
 403 CLASS="LITERAL"
 404 ><A
 405 HREF="catalog-pg-operator.html"
 406 ><TT
 407 CLASS="STRUCTNAME"
 408 >pg_operator</TT
 409 ></A
 410 >.oid</TT
 411 ></TD
 412 ><TD
 413 >       If this operator supports merge joins, the operator that sorts
 414        the type of the left-hand operand (<TT
 415 CLASS="LITERAL"
 416 >L&lt;L</TT
 417 >)
 418       </TD
 419 ></TR
 420 ><TR
 421 ><TD
 422 ><TT
 423 CLASS="STRUCTFIELD"
 424 >oprrsortop</TT
 425 ></TD
 426 ><TD
 427 ><TT
 428 CLASS="TYPE"
 429 >oid</TT
 430 ></TD
 431 ><TD
 432 ><TT
 433 CLASS="LITERAL"
 434 ><A
 435 HREF="catalog-pg-operator.html"
 436 ><TT
 437 CLASS="STRUCTNAME"
 438 >pg_operator</TT
 439 ></A
 440 >.oid</TT
 441 ></TD
 442 ><TD
 443 >       If this operator supports merge joins, the operator that sorts
 444        the type of the right-hand operand (<TT
 445 CLASS="LITERAL"
 446 >R&lt;R</TT
 447 >)
 448       </TD
 449 ></TR
 450 ><TR
 451 ><TD
 452 ><TT
 453 CLASS="STRUCTFIELD"
 454 >oprltcmpop</TT
 455 ></TD
 456 ><TD
 457 ><TT
 458 CLASS="TYPE"
 459 >oid</TT
 460 ></TD
 461 ><TD
 462 ><TT
 463 CLASS="LITERAL"
 464 ><A
 465 HREF="catalog-pg-operator.html"
 466 ><TT
 467 CLASS="STRUCTNAME"
 468 >pg_operator</TT
 469 ></A
 470 >.oid</TT
 471 ></TD
 472 ><TD
 473 >       If this operator supports merge joins, the less-than operator that
 474        compares the left and right operand types (<TT
 475 CLASS="LITERAL"
 476 >L&lt;R</TT
 477 >)
 478       </TD
 479 ></TR
 480 ><TR
 481 ><TD
 482 ><TT
 483 CLASS="STRUCTFIELD"
 484 >oprgtcmpop</TT
 485 ></TD
 486 ><TD
 487 ><TT
 488 CLASS="TYPE"
 489 >oid</TT
 490 ></TD
 491 ><TD
 492 ><TT
 493 CLASS="LITERAL"
 494 ><A
 495 HREF="catalog-pg-operator.html"
 496 ><TT
 497 CLASS="STRUCTNAME"
 498 >pg_operator</TT
 499 ></A
 500 >.oid</TT
 501 ></TD
 502 ><TD
 503 >       If this operator supports merge joins, the greater-than operator that
 504        compares the left and right operand types (<TT
 505 CLASS="LITERAL"
 506 >L&gt;R</TT
 507 >)
 508       </TD
 509 ></TR
 510 ><TR
 511 ><TD
 512 ><TT
 513 CLASS="STRUCTFIELD"
 514 >oprcode</TT
 515 ></TD
 516 ><TD
 517 ><TT
 518 CLASS="TYPE"
 519 >regproc</TT
 520 ></TD
 521 ><TD
 522 ><TT
 523 CLASS="LITERAL"
 524 ><A
 525 HREF="catalog-pg-proc.html"
 526 ><TT
 527 CLASS="STRUCTNAME"
 528 >pg_proc</TT
 529 ></A
 530 >.oid</TT
 531 ></TD
 532 ><TD
 533 >Function that implements this operator</TD
 534 ></TR
 535 ><TR
 536 ><TD
 537 ><TT
 538 CLASS="STRUCTFIELD"
 539 >oprrest</TT
 540 ></TD
 541 ><TD
 542 ><TT
 543 CLASS="TYPE"
 544 >regproc</TT
 545 ></TD
 546 ><TD
 547 ><TT
 548 CLASS="LITERAL"
 549 ><A
 550 HREF="catalog-pg-proc.html"
 551 ><TT
 552 CLASS="STRUCTNAME"
 553 >pg_proc</TT
 554 ></A
 555 >.oid</TT
 556 ></TD
 557 ><TD
 558 >Restriction selectivity estimation function for this operator</TD
 559 ></TR
 560 ><TR
 561 ><TD
 562 ><TT
 563 CLASS="STRUCTFIELD"
 564 >oprjoin</TT
 565 ></TD
 566 ><TD
 567 ><TT
 568 CLASS="TYPE"
 569 >regproc</TT
 570 ></TD
 571 ><TD
 572 ><TT
 573 CLASS="LITERAL"
 574 ><A
 575 HREF="catalog-pg-proc.html"
 576 ><TT
 577 CLASS="STRUCTNAME"
 578 >pg_proc</TT
 579 ></A
 580 >.oid</TT
 581 ></TD
 582 ><TD
 583 >Join selectivity estimation function for this operator</TD
 584 ></TR
 585 ></TBODY
 586 ></TABLE
 587 ></DIV
 588 ><P
 589 >   Unused column contain zeroes, for example <TT
 590 CLASS="STRUCTFIELD"
 591 >oprleft</TT
 592 > is zero for a
 593    prefix operator.
 594   </P
 595 ></DIV
 596 ><DIV
 597 CLASS="NAVFOOTER"
 598 ><HR
 599 ALIGN="LEFT"
 600 WIDTH="100%"><TABLE
 601 SUMMARY="Footer navigation table"
 602 WIDTH="100%"
 603 BORDER="0"
 604 CELLPADDING="0"
 605 CELLSPACING="0"
 606 ><TR
 607 ><TD
 608 WIDTH="33%"
 609 ALIGN="left"
 610 VALIGN="top"
 611 ><A
 612 HREF="catalog-pg-opclass.html"
 613 ACCESSKEY="P"
 614 >Prev</A
 615 ></TD
 616 ><TD
 617 WIDTH="34%"
 618 ALIGN="center"
 619 VALIGN="top"
 620 ><A
 621 HREF="index.html"
 622 ACCESSKEY="H"
 623 >Home</A
 624 ></TD
 625 ><TD
 626 WIDTH="33%"
 627 ALIGN="right"
 628 VALIGN="top"
 629 ><A
 630 HREF="catalog-pg-proc.html"
 631 ACCESSKEY="N"
 632 >Next</A
 633 ></TD
 634 ></TR
 635 ><TR
 636 ><TD
 637 WIDTH="33%"
 638 ALIGN="left"
 639 VALIGN="top"
 640 ><TT
 641 CLASS="STRUCTNAME"
 642 >pg_opclass</TT
 643 ></TD
 644 ><TD
 645 WIDTH="34%"
 646 ALIGN="center"
 647 VALIGN="top"
 648 ><A
 649 HREF="catalogs.html"
 650 ACCESSKEY="U"
 651 >Up</A
 652 ></TD
 653 ><TD
 654 WIDTH="33%"
 655 ALIGN="right"
 656 VALIGN="top"
 657 ><TT
 658 CLASS="STRUCTNAME"
 659 >pg_proc</TT
 660 ></TD
 661 ></TR
 662 ></TABLE
 663 ></DIV
 664 ></BODY
 665 ></HTML
 666 >