/* -------------------------------------------------------------------------
*
* pg_operator.data
* definition of the system "operator" relation (pg_operator)
* along with the relation's initial contents.
*
*
* Portions Copyright (c) 1996-2012, PostgreSQL Global Development Group
* Portions Copyright (c) 1994, Regents of the University of California
* Portions Copyright (c) 2020 Huawei Technologies Co.,Ltd.
* Portions Copyright (c) 2021, openGauss Contributors
*
* src/include/catalog/pg_operator.h
*
* NOTES
* the genbki.pl script reads this file and generates .bki
* information from the DATA() statements.
*
* XXX do NOT break up DATA() statements into multiple lines!
* the scripts are not as smart as you might think...
*
* -------------------------------------------------------------------------
*/
CATALOG(pg_operator,2617) BKI_SCHEMA_MACRO
{
NameData oprname; /* name of operator */
Oid oprnamespace; /* OID of namespace containing this oper */
Oid oprowner; /* operator owner */
char oprkind; /* 'l', 'r', or 'b' */
bool oprcanmerge; /* can be used in merge join? */
bool oprcanhash; /* can be used in hash join? */
Oid oprleft; /* left arg type, or 0 if 'l' oprkind */
Oid oprright; /* right arg type, or 0 if 'r' oprkind */
Oid oprresult; /* result datatype */
Oid oprcom; /* OID of commutator oper, or 0 if none */
Oid oprnegate; /* OID of negator oper, or 0 if none */
regproc oprcode; /* OID of underlying function */
regproc oprrest; /* OID of restriction estimator, or 0 */
regproc oprjoin; /* OID of join estimator, or 0 */
} FormData_pg_operator;
DATA(insert OID = 15 ("=" PGNSP PGUID b t t 23 20 16 416 36 int48eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 36 ("<>" PGNSP PGUID b f f 23 20 16 417 15 int48ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 37 ("<" PGNSP PGUID b f f 23 20 16 419 82 int48lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 76 (">" PGNSP PGUID b f f 23 20 16 418 80 int48gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 80 ("<=" PGNSP PGUID b f f 23 20 16 430 76 int48le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 82 (">=" PGNSP PGUID b f f 23 20 16 420 37 int48ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 58 ("<" PGNSP PGUID b f f 16 16 16 59 1695 boollt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 59 (">" PGNSP PGUID b f f 16 16 16 58 1694 boolgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 85 ("<>" PGNSP PGUID b f f 16 16 16 85 91 boolne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 91 ("=" PGNSP PGUID b t t 16 16 16 91 85 booleq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1694 ("<=" PGNSP PGUID b f f 16 16 16 1695 59 boolle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1695 (">=" PGNSP PGUID b f f 16 16 16 1694 58 boolge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 92 ("=" PGNSP PGUID b t t 18 18 16 92 630 chareq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 93 ("=" PGNSP PGUID b t t 19 19 16 93 643 nameeq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 94 ("=" PGNSP PGUID b t t 21 21 16 94 519 int2eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 95 ("<" PGNSP PGUID b f f 21 21 16 520 524 int2lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 96 ("=" PGNSP PGUID b t t 23 23 16 96 518 int4eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 97 ("<" PGNSP PGUID b f f 23 23 16 521 525 int4lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 98 ("=" PGNSP PGUID b t t 25 25 16 98 531 texteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 349 ("||" PGNSP PGUID b f f 2277 2283 2277 0 0 array_append - - ));
DESCR("append element onto end of array");
DATA(insert OID = 374 ("||" PGNSP PGUID b f f 2283 2277 2277 0 0 array_prepend - - ));
DESCR("prepend element onto front of array");
DATA(insert OID = 375 ("||" PGNSP PGUID b f f 2277 2277 2277 0 0 array_cat - - ));
DESCR("concatenate");
DATA(insert OID = 352 ("=" PGNSP PGUID b f t 28 28 16 352 0 xideq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 353 ("=" PGNSP PGUID b f f 28 20 16 0 0 xideqint8 eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 354 ("<" PGNSP PGUID b f f 28 28 16 0 0 xidlt neqsel neqjoinsel));
DESCR("less than");
DATA(insert OID = 355 ("=" PGNSP PGUID b f t 31 31 16 355 0 xideq4 eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 356 ("=" PGNSP PGUID b f f 31 23 16 0 0 xideqint4 eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 357 ("<" PGNSP PGUID b f f 31 31 16 0 0 xidlt4 neqsel neqjoinsel));
DESCR("less than");
DATA(insert OID = 388 ("!" PGNSP PGUID r f f 20 0 1700 0 0 numeric_fac - -));
DESCR("factorial");
DATA(insert OID = 389 ("!!" PGNSP PGUID l f f 0 20 1700 0 0 numeric_fac - -));
DESCR("deprecated, use ! instead");
DATA(insert OID = 385 ("=" PGNSP PGUID b f t 29 29 16 385 0 cideq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 386 ("=" PGNSP PGUID b f t 22 22 16 386 0 int2vectoreq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 387 ("=" PGNSP PGUID b t f 27 27 16 387 402 tideq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 402 ("<>" PGNSP PGUID b f f 27 27 16 402 387 tidne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2799 ("<" PGNSP PGUID b f f 27 27 16 2800 2802 tidlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2800 (">" PGNSP PGUID b f f 27 27 16 2799 2801 tidgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2801 ("<=" PGNSP PGUID b f f 27 27 16 2802 2800 tidle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2802 (">=" PGNSP PGUID b f f 27 27 16 2801 2799 tidge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 410 ("=" PGNSP PGUID b t t 20 20 16 410 411 int8eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 411 ("<>" PGNSP PGUID b f f 20 20 16 411 410 int8ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 412 ("<" PGNSP PGUID b f f 20 20 16 413 415 int8lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 413 (">" PGNSP PGUID b f f 20 20 16 412 414 int8gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 414 ("<=" PGNSP PGUID b f f 20 20 16 415 413 int8le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 415 (">=" PGNSP PGUID b f f 20 20 16 414 412 int8ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 416 ("=" PGNSP PGUID b t t 20 23 16 15 417 int84eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 417 ("<>" PGNSP PGUID b f f 20 23 16 36 416 int84ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 418 ("<" PGNSP PGUID b f f 20 23 16 76 430 int84lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 419 (">" PGNSP PGUID b f f 20 23 16 37 420 int84gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 420 ("<=" PGNSP PGUID b f f 20 23 16 82 419 int84le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 430 (">=" PGNSP PGUID b f f 20 23 16 80 418 int84ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 439 ("%" PGNSP PGUID b f f 20 20 20 0 0 int8mod - -));
DESCR("modulus");
DATA(insert OID = 473 ("@" PGNSP PGUID l f f 0 20 20 0 0 int8abs - -));
DESCR("absolute value");
DATA(insert OID = 484 ("-" PGNSP PGUID l f f 0 20 20 0 0 int8um - -));
DESCR("negate");
DATA(insert OID = 485 ("<<" PGNSP PGUID b f f 604 604 16 0 0 poly_left positionsel positionjoinsel));
DESCR("is left of");
DATA(insert OID = 486 ("&<" PGNSP PGUID b f f 604 604 16 0 0 poly_overleft positionsel positionjoinsel));
DESCR("overlaps or is left of");
DATA(insert OID = 487 ("&>" PGNSP PGUID b f f 604 604 16 0 0 poly_overright positionsel positionjoinsel));
DESCR("overlaps or is right of");
DATA(insert OID = 488 (">>" PGNSP PGUID b f f 604 604 16 0 0 poly_right positionsel positionjoinsel));
DESCR("is right of");
DATA(insert OID = 489 ("<@" PGNSP PGUID b f f 604 604 16 490 0 poly_contained contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 490 ("@>" PGNSP PGUID b f f 604 604 16 489 0 poly_contain contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 491 ("~=" PGNSP PGUID b f f 604 604 16 491 0 poly_same eqsel eqjoinsel));
DESCR("same as");
DATA(insert OID = 492 ("&&" PGNSP PGUID b f f 604 604 16 492 0 poly_overlap areasel areajoinsel));
DESCR("overlaps");
DATA(insert OID = 493 ("<<" PGNSP PGUID b f f 603 603 16 0 0 box_left positionsel positionjoinsel));
DESCR("is left of");
DATA(insert OID = 494 ("&<" PGNSP PGUID b f f 603 603 16 0 0 box_overleft positionsel positionjoinsel));
DESCR("overlaps or is left of");
DATA(insert OID = 495 ("&>" PGNSP PGUID b f f 603 603 16 0 0 box_overright positionsel positionjoinsel));
DESCR("overlaps or is right of");
DATA(insert OID = 496 (">>" PGNSP PGUID b f f 603 603 16 0 0 box_right positionsel positionjoinsel));
DESCR("is right of");
DATA(insert OID = 497 ("<@" PGNSP PGUID b f f 603 603 16 498 0 box_contained contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 498 ("@>" PGNSP PGUID b f f 603 603 16 497 0 box_contain contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 499 ("~=" PGNSP PGUID b f f 603 603 16 499 0 box_same eqsel eqjoinsel));
DESCR("same as");
DATA(insert OID = 500 ("&&" PGNSP PGUID b f f 603 603 16 500 0 box_overlap areasel areajoinsel));
DESCR("overlaps");
DATA(insert OID = 501 (">=" PGNSP PGUID b f f 603 603 16 505 504 box_ge areasel areajoinsel));
DESCR("greater than or equal by area");
DATA(insert OID = 502 (">" PGNSP PGUID b f f 603 603 16 504 505 box_gt areasel areajoinsel));
DESCR("greater than by area");
DATA(insert OID = 503 ("=" PGNSP PGUID b f f 603 603 16 503 0 box_eq eqsel eqjoinsel));
DESCR("equal by area");
DATA(insert OID = 504 ("<" PGNSP PGUID b f f 603 603 16 502 501 box_lt areasel areajoinsel));
DESCR("less than by area");
DATA(insert OID = 505 ("<=" PGNSP PGUID b f f 603 603 16 501 502 box_le areasel areajoinsel));
DESCR("less than or equal by area");
DATA(insert OID = 506 (">^" PGNSP PGUID b f f 600 600 16 0 0 point_above positionsel positionjoinsel));
DESCR("is above");
DATA(insert OID = 507 ("<<" PGNSP PGUID b f f 600 600 16 0 0 point_left positionsel positionjoinsel));
DESCR("is left of");
DATA(insert OID = 508 (">>" PGNSP PGUID b f f 600 600 16 0 0 point_right positionsel positionjoinsel));
DESCR("is right of");
DATA(insert OID = 509 ("<^" PGNSP PGUID b f f 600 600 16 0 0 point_below positionsel positionjoinsel));
DESCR("is below");
DATA(insert OID = 510 ("~=" PGNSP PGUID b f f 600 600 16 510 713 point_eq eqsel eqjoinsel));
DESCR("same as");
DATA(insert OID = 511 ("<@" PGNSP PGUID b f f 600 603 16 433 0 on_pb contsel contjoinsel));
DESCR("point inside box");
DATA(insert OID = 433 ("@>" PGNSP PGUID b f f 603 600 16 511 0 box_contain_pt contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 512 ("<@" PGNSP PGUID b f f 600 602 16 755 0 on_ppath - -));
DESCR("point within closed path, or point on open path");
DATA(insert OID = 513 ("@@" PGNSP PGUID l f f 0 603 600 0 0 box_center - -));
DESCR("center of");
DATA(insert OID = 514 ("*" PGNSP PGUID b f f 23 23 23 514 0 int4mul - -));
DESCR("multiply");
DATA(insert OID = 517 ("<->" PGNSP PGUID b f f 600 600 701 517 0 point_distance - -));
DESCR("distance between");
DATA(insert OID = 518 ("<>" PGNSP PGUID b f f 23 23 16 518 96 int4ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 519 ("<>" PGNSP PGUID b f f 21 21 16 519 94 int2ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 520 (">" PGNSP PGUID b f f 21 21 16 95 522 int2gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 521 (">" PGNSP PGUID b f f 23 23 16 97 523 int4gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 522 ("<=" PGNSP PGUID b f f 21 21 16 524 520 int2le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 523 ("<=" PGNSP PGUID b f f 23 23 16 525 521 int4le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 524 (">=" PGNSP PGUID b f f 21 21 16 522 95 int2ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 525 (">=" PGNSP PGUID b f f 23 23 16 523 97 int4ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 526 ("*" PGNSP PGUID b f f 21 21 21 526 0 int2mul - -));
DESCR("multiply");
DATA(insert OID = 527 ("/" PGNSP PGUID b f f 21 21 701 0 0 int2div - -));
DESCR("divide");
DATA(insert OID = 528 ("/" PGNSP PGUID b f f 23 23 701 0 0 int4div - -));
DESCR("divide");
DATA(insert OID = 529 ("%" PGNSP PGUID b f f 21 21 21 0 0 int2mod - -));
DESCR("modulus");
DATA(insert OID = 530 ("%" PGNSP PGUID b f f 23 23 23 0 0 int4mod - -));
DESCR("modulus");
DATA(insert OID = 531 ("<>" PGNSP PGUID b f f 25 25 16 531 98 textne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 532 ("=" PGNSP PGUID b t t 21 23 16 533 538 int24eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 533 ("=" PGNSP PGUID b t t 23 21 16 532 539 int42eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 534 ("<" PGNSP PGUID b f f 21 23 16 537 542 int24lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 535 ("<" PGNSP PGUID b f f 23 21 16 536 543 int42lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 536 (">" PGNSP PGUID b f f 21 23 16 535 540 int24gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 537 (">" PGNSP PGUID b f f 23 21 16 534 541 int42gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 538 ("<>" PGNSP PGUID b f f 21 23 16 539 532 int24ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 539 ("<>" PGNSP PGUID b f f 23 21 16 538 533 int42ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 540 ("<=" PGNSP PGUID b f f 21 23 16 543 536 int24le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 541 ("<=" PGNSP PGUID b f f 23 21 16 542 537 int42le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 542 (">=" PGNSP PGUID b f f 21 23 16 541 534 int24ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 543 (">=" PGNSP PGUID b f f 23 21 16 540 535 int42ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 544 ("*" PGNSP PGUID b f f 21 23 23 545 0 int24mul - -));
DESCR("multiply");
DATA(insert OID = 545 ("*" PGNSP PGUID b f f 23 21 23 544 0 int42mul - -));
DESCR("multiply");
DATA(insert OID = 546 ("/" PGNSP PGUID b f f 21 23 701 0 0 int24div - -));
DESCR("divide");
DATA(insert OID = 547 ("/" PGNSP PGUID b f f 23 21 701 0 0 int42div - -));
DESCR("divide");
DATA(insert OID = 550 ("+" PGNSP PGUID b f f 21 21 21 550 0 int2pl - -));
DESCR("add");
DATA(insert OID = 551 ("+" PGNSP PGUID b f f 23 23 23 551 0 int4pl - -));
DESCR("add");
DATA(insert OID = 552 ("+" PGNSP PGUID b f f 21 23 23 553 0 int24pl - -));
DESCR("add");
DATA(insert OID = 553 ("+" PGNSP PGUID b f f 23 21 23 552 0 int42pl - -));
DESCR("add");
DATA(insert OID = 554 ("-" PGNSP PGUID b f f 21 21 21 0 0 int2mi - -));
DESCR("subtract");
DATA(insert OID = 555 ("-" PGNSP PGUID b f f 23 23 23 0 0 int4mi - -));
DESCR("subtract");
DATA(insert OID = 556 ("-" PGNSP PGUID b f f 21 23 23 0 0 int24mi - -));
DESCR("subtract");
DATA(insert OID = 557 ("-" PGNSP PGUID b f f 23 21 23 0 0 int42mi - -));
DESCR("subtract");
DATA(insert OID = 558 ("-" PGNSP PGUID l f f 0 23 23 0 0 int4um - -));
DESCR("negate");
DATA(insert OID = 559 ("-" PGNSP PGUID l f f 0 21 21 0 0 int2um - -));
DESCR("negate");
DATA(insert OID = 560 ("=" PGNSP PGUID b t t 702 702 16 560 561 abstimeeq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 561 ("<>" PGNSP PGUID b f f 702 702 16 561 560 abstimene neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 562 ("<" PGNSP PGUID b f f 702 702 16 563 565 abstimelt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 563 (">" PGNSP PGUID b f f 702 702 16 562 564 abstimegt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 564 ("<=" PGNSP PGUID b f f 702 702 16 565 563 abstimele scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 565 (">=" PGNSP PGUID b f f 702 702 16 564 562 abstimege scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 566 ("=" PGNSP PGUID b t t 703 703 16 566 567 reltimeeq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 567 ("<>" PGNSP PGUID b f f 703 703 16 567 566 reltimene neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 568 ("<" PGNSP PGUID b f f 703 703 16 569 571 reltimelt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 569 (">" PGNSP PGUID b f f 703 703 16 568 570 reltimegt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 570 ("<=" PGNSP PGUID b f f 703 703 16 571 569 reltimele scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 571 (">=" PGNSP PGUID b f f 703 703 16 570 568 reltimege scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 572 ("~=" PGNSP PGUID b f f 704 704 16 572 0 tintervalsame eqsel eqjoinsel));
DESCR("same as");
DATA(insert OID = 573 ("<<" PGNSP PGUID b f f 704 704 16 0 0 tintervalct - -));
DESCR("contains");
DATA(insert OID = 574 ("&&" PGNSP PGUID b f f 704 704 16 574 0 tintervalov - -));
DESCR("overlaps");
DATA(insert OID = 575 ("#=" PGNSP PGUID b f f 704 703 16 0 576 tintervalleneq - -));
DESCR("equal by length");
DATA(insert OID = 576 ("#<>" PGNSP PGUID b f f 704 703 16 0 575 tintervallenne - -));
DESCR("not equal by length");
DATA(insert OID = 577 ("#<" PGNSP PGUID b f f 704 703 16 0 580 tintervallenlt - -));
DESCR("less than by length");
DATA(insert OID = 578 ("#>" PGNSP PGUID b f f 704 703 16 0 579 tintervallengt - -));
DESCR("greater than by length");
DATA(insert OID = 579 ("#<=" PGNSP PGUID b f f 704 703 16 0 578 tintervallenle - -));
DESCR("less than or equal by length");
DATA(insert OID = 580 ("#>=" PGNSP PGUID b f f 704 703 16 0 577 tintervallenge - -));
DESCR("greater than or equal by length");
DATA(insert OID = 581 ("+" PGNSP PGUID b f f 702 703 702 0 0 timepl - -));
DESCR("add");
DATA(insert OID = 582 ("-" PGNSP PGUID b f f 702 703 702 0 0 timemi - -));
DESCR("subtract");
DATA(insert OID = 583 ("<?>" PGNSP PGUID b f f 702 704 16 0 0 intinterval - -));
DESCR("is contained by");
DATA(insert OID = 584 ("-" PGNSP PGUID l f f 0 700 700 0 0 float4um - -));
DESCR("negate");
DATA(insert OID = 585 ("-" PGNSP PGUID l f f 0 701 701 0 0 float8um - -));
DESCR("negate");
DATA(insert OID = 586 ("+" PGNSP PGUID b f f 700 700 700 586 0 float4pl - -));
DESCR("add");
DATA(insert OID = 587 ("-" PGNSP PGUID b f f 700 700 700 0 0 float4mi - -));
DESCR("subtract");
DATA(insert OID = 588 ("/" PGNSP PGUID b f f 700 700 700 0 0 float4div - -));
DESCR("divide");
DATA(insert OID = 589 ("*" PGNSP PGUID b f f 700 700 700 589 0 float4mul - -));
DESCR("multiply");
DATA(insert OID = 590 ("@" PGNSP PGUID l f f 0 700 700 0 0 float4abs - -));
DESCR("absolute value");
DATA(insert OID = 591 ("+" PGNSP PGUID b f f 701 701 701 591 0 float8pl - -));
DESCR("add");
DATA(insert OID = 592 ("-" PGNSP PGUID b f f 701 701 701 0 0 float8mi - -));
DESCR("subtract");
DATA(insert OID = 593 ("/" PGNSP PGUID b f f 701 701 701 0 0 float8div - -));
DESCR("divide");
DATA(insert OID = 594 ("*" PGNSP PGUID b f f 701 701 701 594 0 float8mul - -));
DESCR("multiply");
DATA(insert OID = 595 ("@" PGNSP PGUID l f f 0 701 701 0 0 float8abs - -));
DESCR("absolute value");
DATA(insert OID = 596 ("|/" PGNSP PGUID l f f 0 701 701 0 0 dsqrt - -));
DESCR("square root");
DATA(insert OID = 597 ("||/" PGNSP PGUID l f f 0 701 701 0 0 dcbrt - -));
DESCR("cube root");
DATA(insert OID = 1284 ("|" PGNSP PGUID l f f 0 704 702 0 0 tintervalstart - -));
DESCR("start of interval");
DATA(insert OID = 606 ("<#>" PGNSP PGUID b f f 702 702 704 0 0 mktinterval - -));
DESCR("convert to tinterval");
DATA(insert OID = 607 ("=" PGNSP PGUID b t t 26 26 16 607 608 oideq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 608 ("<>" PGNSP PGUID b f f 26 26 16 608 607 oidne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 609 ("<" PGNSP PGUID b f f 26 26 16 610 612 oidlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 610 (">" PGNSP PGUID b f f 26 26 16 609 611 oidgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 611 ("<=" PGNSP PGUID b f f 26 26 16 612 610 oidle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 612 (">=" PGNSP PGUID b f f 26 26 16 611 609 oidge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 644 ("<>" PGNSP PGUID b f f 30 30 16 644 649 oidvectorne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 645 ("<" PGNSP PGUID b f f 30 30 16 646 648 oidvectorlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 646 (">" PGNSP PGUID b f f 30 30 16 645 647 oidvectorgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 647 ("<=" PGNSP PGUID b f f 30 30 16 648 646 oidvectorle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 648 (">=" PGNSP PGUID b f f 30 30 16 647 645 oidvectorge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 649 ("=" PGNSP PGUID b t t 30 30 16 649 644 oidvectoreq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 613 ("<->" PGNSP PGUID b f f 600 628 701 0 0 dist_pl - -));
DESCR("distance between");
DATA(insert OID = 614 ("<->" PGNSP PGUID b f f 600 601 701 0 0 dist_ps - -));
DESCR("distance between");
DATA(insert OID = 615 ("<->" PGNSP PGUID b f f 600 603 701 0 0 dist_pb - -));
DESCR("distance between");
DATA(insert OID = 616 ("<->" PGNSP PGUID b f f 601 628 701 0 0 dist_sl - -));
DESCR("distance between");
DATA(insert OID = 617 ("<->" PGNSP PGUID b f f 601 603 701 0 0 dist_sb - -));
DESCR("distance between");
DATA(insert OID = 618 ("<->" PGNSP PGUID b f f 600 602 701 0 0 dist_ppath - -));
DESCR("distance between");
DATA(insert OID = 620 ("=" PGNSP PGUID b t t 700 700 16 620 621 float4eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 621 ("<>" PGNSP PGUID b f f 700 700 16 621 620 float4ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 622 ("<" PGNSP PGUID b f f 700 700 16 623 625 float4lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 623 (">" PGNSP PGUID b f f 700 700 16 622 624 float4gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 624 ("<=" PGNSP PGUID b f f 700 700 16 625 623 float4le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 625 (">=" PGNSP PGUID b f f 700 700 16 624 622 float4ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 630 ("<>" PGNSP PGUID b f f 18 18 16 630 92 charne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 631 ("<" PGNSP PGUID b f f 18 18 16 633 634 charlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 632 ("<=" PGNSP PGUID b f f 18 18 16 634 633 charle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 633 (">" PGNSP PGUID b f f 18 18 16 631 632 chargt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 634 (">=" PGNSP PGUID b f f 18 18 16 632 631 charge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 5513 ("=" PGNSP PGUID b t t 5545 5545 16 5513 5514 int1eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 5514 ("<>" PGNSP PGUID b f f 5545 5545 16 5514 5513 int1ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 5515 ("<" PGNSP PGUID b f f 5545 5545 16 5517 5518 int1lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 5516 ("<=" PGNSP PGUID b f f 5545 5545 16 5518 5517 int1le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 5517 (">" PGNSP PGUID b f f 5545 5545 16 5515 5516 int1gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 5518 (">=" PGNSP PGUID b f f 5545 5545 16 5516 5515 int1ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 639 ("~" PGNSP PGUID b f f 19 25 16 0 640 nameregexeq regexeqsel regexeqjoinsel));
DESCR("matches regular expression, case-sensitive");
DATA(insert OID = 640 ("!~" PGNSP PGUID b f f 19 25 16 0 639 nameregexne regexnesel regexnejoinsel));
DESCR("does not match regular expression, case-sensitive");
DATA(insert OID = 641 ("~" PGNSP PGUID b f f 25 25 16 0 642 textregexeq regexeqsel regexeqjoinsel));
DESCR("matches regular expression, case-sensitive");
DATA(insert OID = 642 ("!~" PGNSP PGUID b f f 25 25 16 0 641 textregexne regexnesel regexnejoinsel));
DESCR("does not match regular expression, case-sensitive");
DATA(insert OID = 643 ("<>" PGNSP PGUID b f f 19 19 16 643 93 namene neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 654 ("||" PGNSP PGUID b f f 25 25 25 0 0 textcat - -));
DESCR("concatenate");
DATA(insert OID = 660 ("<" PGNSP PGUID b f f 19 19 16 662 663 namelt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 661 ("<=" PGNSP PGUID b f f 19 19 16 663 662 namele scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 662 (">" PGNSP PGUID b f f 19 19 16 660 661 namegt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 663 (">=" PGNSP PGUID b f f 19 19 16 661 660 namege scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 664 ("<" PGNSP PGUID b f f 25 25 16 666 667 text_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 665 ("<=" PGNSP PGUID b f f 25 25 16 667 666 text_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 666 (">" PGNSP PGUID b f f 25 25 16 664 665 text_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 667 (">=" PGNSP PGUID b f f 25 25 16 665 664 text_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 670 ("=" PGNSP PGUID b t t 701 701 16 670 671 float8eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 671 ("<>" PGNSP PGUID b f f 701 701 16 671 670 float8ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 672 ("<" PGNSP PGUID b f f 701 701 16 674 675 float8lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 673 ("<=" PGNSP PGUID b f f 701 701 16 675 674 float8le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 674 (">" PGNSP PGUID b f f 701 701 16 672 673 float8gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 675 (">=" PGNSP PGUID b f f 701 701 16 673 672 float8ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 682 ("@" PGNSP PGUID l f f 0 21 21 0 0 int2abs - -));
DESCR("absolute value");
DATA(insert OID = 684 ("+" PGNSP PGUID b f f 20 20 20 684 0 int8pl - -));
DESCR("add");
DATA(insert OID = 685 ("-" PGNSP PGUID b f f 20 20 20 0 0 int8mi - -));
DESCR("subtract");
DATA(insert OID = 686 ("*" PGNSP PGUID b f f 20 20 20 686 0 int8mul - -));
DESCR("multiply");
DATA(insert OID = 687 ("/" PGNSP PGUID b f f 20 20 701 0 0 int8div - -));
DESCR("divide");
DATA(insert OID = 688 ("+" PGNSP PGUID b f f 20 23 20 692 0 int84pl - -));
DESCR("add");
DATA(insert OID = 689 ("-" PGNSP PGUID b f f 20 23 20 0 0 int84mi - -));
DESCR("subtract");
DATA(insert OID = 690 ("*" PGNSP PGUID b f f 20 23 20 694 0 int84mul - -));
DESCR("multiply");
DATA(insert OID = 691 ("/" PGNSP PGUID b f f 20 23 701 0 0 int84div - -));
DESCR("divide");
DATA(insert OID = 692 ("+" PGNSP PGUID b f f 23 20 20 688 0 int48pl - -));
DESCR("add");
DATA(insert OID = 693 ("-" PGNSP PGUID b f f 23 20 20 0 0 int48mi - -));
DESCR("subtract");
DATA(insert OID = 694 ("*" PGNSP PGUID b f f 23 20 20 690 0 int48mul - -));
DESCR("multiply");
DATA(insert OID = 695 ("/" PGNSP PGUID b f f 23 20 701 0 0 int48div - -));
DESCR("divide");
DATA(insert OID = 818 ("+" PGNSP PGUID b f f 20 21 20 822 0 int82pl - -));
DESCR("add");
DATA(insert OID = 819 ("-" PGNSP PGUID b f f 20 21 20 0 0 int82mi - -));
DESCR("subtract");
DATA(insert OID = 820 ("*" PGNSP PGUID b f f 20 21 20 824 0 int82mul - -));
DESCR("multiply");
DATA(insert OID = 821 ("/" PGNSP PGUID b f f 20 21 701 0 0 int82div - -));
DESCR("divide");
DATA(insert OID = 822 ("+" PGNSP PGUID b f f 21 20 20 818 0 int28pl - -));
DESCR("add");
DATA(insert OID = 823 ("-" PGNSP PGUID b f f 21 20 20 0 0 int28mi - -));
DESCR("subtract");
DATA(insert OID = 824 ("*" PGNSP PGUID b f f 21 20 20 820 0 int28mul - -));
DESCR("multiply");
DATA(insert OID = 825 ("/" PGNSP PGUID b f f 21 20 701 0 0 int28div - -));
DESCR("divide");
DATA(insert OID = 706 ("<->" PGNSP PGUID b f f 603 603 701 706 0 box_distance - -));
DESCR("distance between");
DATA(insert OID = 707 ("<->" PGNSP PGUID b f f 602 602 701 707 0 path_distance - -));
DESCR("distance between");
DATA(insert OID = 708 ("<->" PGNSP PGUID b f f 628 628 701 708 0 line_distance - -));
DESCR("distance between");
DATA(insert OID = 709 ("<->" PGNSP PGUID b f f 601 601 701 709 0 lseg_distance - -));
DESCR("distance between");
DATA(insert OID = 712 ("<->" PGNSP PGUID b f f 604 604 701 712 0 poly_distance - -));
DESCR("distance between");
DATA(insert OID = 713 ("<>" PGNSP PGUID b f f 600 600 16 713 510 point_ne neqsel neqjoinsel));
DESCR("not equal");
/* add translation/rotation/scaling operators for geometric types. - thomas 97/05/10 */
DATA(insert OID = 731 ("+" PGNSP PGUID b f f 600 600 600 731 0 point_add - -));
DESCR("add points (translate)");
DATA(insert OID = 732 ("-" PGNSP PGUID b f f 600 600 600 0 0 point_sub - -));
DESCR("subtract points (translate)");
DATA(insert OID = 733 ("*" PGNSP PGUID b f f 600 600 600 733 0 point_mul - -));
DESCR("multiply points (scale/rotate)");
DATA(insert OID = 734 ("/" PGNSP PGUID b f f 600 600 600 0 0 point_div - -));
DESCR("divide points (scale/rotate)");
DATA(insert OID = 735 ("+" PGNSP PGUID b f f 602 602 602 735 0 path_add - -));
DESCR("concatenate");
DATA(insert OID = 736 ("+" PGNSP PGUID b f f 602 600 602 0 0 path_add_pt - -));
DESCR("add (translate path)");
DATA(insert OID = 737 ("-" PGNSP PGUID b f f 602 600 602 0 0 path_sub_pt - -));
DESCR("subtract (translate path)");
DATA(insert OID = 738 ("*" PGNSP PGUID b f f 602 600 602 0 0 path_mul_pt - -));
DESCR("multiply (rotate/scale path)");
DATA(insert OID = 739 ("/" PGNSP PGUID b f f 602 600 602 0 0 path_div_pt - -));
DESCR("divide (rotate/scale path)");
DATA(insert OID = 755 ("@>" PGNSP PGUID b f f 602 600 16 512 0 path_contain_pt - -));
DESCR("contains");
DATA(insert OID = 756 ("<@" PGNSP PGUID b f f 600 604 16 757 0 pt_contained_poly contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 757 ("@>" PGNSP PGUID b f f 604 600 16 756 0 poly_contain_pt contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 758 ("<@" PGNSP PGUID b f f 600 718 16 759 0 pt_contained_circle contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 759 ("@>" PGNSP PGUID b f f 718 600 16 758 0 circle_contain_pt contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 773 ("@" PGNSP PGUID l f f 0 23 23 0 0 int4abs - -));
DESCR("absolute value");
/* additional operators for geometric types - thomas 1997-07-09 */
DATA(insert OID = 792 ("=" PGNSP PGUID b f f 602 602 16 792 0 path_n_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 793 ("<" PGNSP PGUID b f f 602 602 16 794 0 path_n_lt - -));
DESCR("less than");
DATA(insert OID = 794 (">" PGNSP PGUID b f f 602 602 16 793 0 path_n_gt - -));
DESCR("greater than");
DATA(insert OID = 795 ("<=" PGNSP PGUID b f f 602 602 16 796 0 path_n_le - -));
DESCR("less than or equal");
DATA(insert OID = 796 (">=" PGNSP PGUID b f f 602 602 16 795 0 path_n_ge - -));
DESCR("greater than or equal");
DATA(insert OID = 797 ("#" PGNSP PGUID l f f 0 602 23 0 0 path_npoints - -));
DESCR("number of points");
DATA(insert OID = 798 ("?#" PGNSP PGUID b f f 602 602 16 0 0 path_inter - -));
DESCR("intersect");
DATA(insert OID = 799 ("@-@" PGNSP PGUID l f f 0 602 701 0 0 path_length - -));
DESCR("sum of path segment lengths");
DATA(insert OID = 800 (">^" PGNSP PGUID b f f 603 603 16 0 0 box_above_eq positionsel positionjoinsel));
DESCR("is above (allows touching)");
DATA(insert OID = 801 ("<^" PGNSP PGUID b f f 603 603 16 0 0 box_below_eq positionsel positionjoinsel));
DESCR("is below (allows touching)");
DATA(insert OID = 802 ("?#" PGNSP PGUID b f f 603 603 16 0 0 box_overlap areasel areajoinsel));
DESCR("deprecated, use && instead");
DATA(insert OID = 803 ("#" PGNSP PGUID b f f 603 603 603 0 0 box_intersect - -));
DESCR("box intersection");
DATA(insert OID = 804 ("+" PGNSP PGUID b f f 603 600 603 0 0 box_add - -));
DESCR("add point to box (translate)");
DATA(insert OID = 805 ("-" PGNSP PGUID b f f 603 600 603 0 0 box_sub - -));
DESCR("subtract point from box (translate)");
DATA(insert OID = 806 ("*" PGNSP PGUID b f f 603 600 603 0 0 box_mul - -));
DESCR("multiply box by point (scale)");
DATA(insert OID = 807 ("/" PGNSP PGUID b f f 603 600 603 0 0 box_div - -));
DESCR("divide box by point (scale)");
DATA(insert OID = 808 ("?-" PGNSP PGUID b f f 600 600 16 808 0 point_horiz - -));
DESCR("horizontally aligned");
DATA(insert OID = 809 ("?|" PGNSP PGUID b f f 600 600 16 809 0 point_vert - -));
DESCR("vertically aligned");
DATA(insert OID = 811 ("=" PGNSP PGUID b t f 704 704 16 811 812 tintervaleq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 812 ("<>" PGNSP PGUID b f f 704 704 16 812 811 tintervalne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 813 ("<" PGNSP PGUID b f f 704 704 16 814 816 tintervallt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 814 (">" PGNSP PGUID b f f 704 704 16 813 815 tintervalgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 815 ("<=" PGNSP PGUID b f f 704 704 16 816 814 tintervalle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 816 (">=" PGNSP PGUID b f f 704 704 16 815 813 tintervalge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 843 ("*" PGNSP PGUID b f f 790 700 790 845 0 cash_mul_flt4 - -));
DESCR("multiply");
DATA(insert OID = 844 ("/" PGNSP PGUID b f f 790 700 790 0 0 cash_div_flt4 - -));
DESCR("divide");
DATA(insert OID = 845 ("*" PGNSP PGUID b f f 700 790 790 843 0 flt4_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 900 ("=" PGNSP PGUID b t f 790 790 16 900 901 cash_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 901 ("<>" PGNSP PGUID b f f 790 790 16 901 900 cash_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 902 ("<" PGNSP PGUID b f f 790 790 16 903 905 cash_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 903 (">" PGNSP PGUID b f f 790 790 16 902 904 cash_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 904 ("<=" PGNSP PGUID b f f 790 790 16 905 903 cash_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 905 (">=" PGNSP PGUID b f f 790 790 16 904 902 cash_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 906 ("+" PGNSP PGUID b f f 790 790 790 906 0 cash_pl - -));
DESCR("add");
DATA(insert OID = 907 ("-" PGNSP PGUID b f f 790 790 790 0 0 cash_mi - -));
DESCR("subtract");
DATA(insert OID = 908 ("*" PGNSP PGUID b f f 790 701 790 916 0 cash_mul_flt8 - -));
DESCR("multiply");
DATA(insert OID = 909 ("/" PGNSP PGUID b f f 790 701 790 0 0 cash_div_flt8 - -));
DESCR("divide");
DATA(insert OID = 3346 ("*" PGNSP PGUID b f f 790 20 790 3349 0 cash_mul_int8 - -));
DESCR("multiply");
DATA(insert OID = 3347 ("/" PGNSP PGUID b f f 790 20 790 0 0 cash_div_int8 - -));
DESCR("divide");
DATA(insert OID = 912 ("*" PGNSP PGUID b f f 790 23 790 917 0 cash_mul_int4 - -));
DESCR("multiply");
DATA(insert OID = 913 ("/" PGNSP PGUID b f f 790 23 790 0 0 cash_div_int4 - -));
DESCR("divide");
DATA(insert OID = 914 ("*" PGNSP PGUID b f f 790 21 790 918 0 cash_mul_int2 - -));
DESCR("multiply");
DATA(insert OID = 915 ("/" PGNSP PGUID b f f 790 21 790 0 0 cash_div_int2 - -));
DESCR("divide");
DATA(insert OID = 3352 ("*" PGNSP PGUID b f f 790 5545 790 3354 0 cash_mul_int1 - -));
DESCR("multiply");
DATA(insert OID = 3353 ("/" PGNSP PGUID b f f 790 5545 790 0 0 cash_div_int1 - -));
DESCR("divide");
DATA(insert OID = 916 ("*" PGNSP PGUID b f f 701 790 790 908 0 flt8_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 3349 ("*" PGNSP PGUID b f f 20 790 790 3346 0 int8_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 917 ("*" PGNSP PGUID b f f 23 790 790 912 0 int4_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 918 ("*" PGNSP PGUID b f f 21 790 790 914 0 int2_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 3354 ("*" PGNSP PGUID b f f 5545 790 790 3352 0 int1_mul_cash - -));
DESCR("multiply");
DATA(insert OID = 3825 ("/" PGNSP PGUID b f f 790 790 701 0 0 cash_div_cash - -));
DESCR("divide");
DATA(insert OID = 965 ("^" PGNSP PGUID b f f 701 701 701 0 0 dpow - -));
DESCR("exponentiation");
DATA(insert OID = 966 ("+" PGNSP PGUID b f f 1034 1033 1034 0 0 aclinsert - -));
DESCR("add/update ACL item");
DATA(insert OID = 967 ("-" PGNSP PGUID b f f 1034 1033 1034 0 0 aclremove - -));
DESCR("remove ACL item");
DATA(insert OID = 968 ("@>" PGNSP PGUID b f f 1034 1033 16 0 0 aclcontains - -));
DESCR("contains");
DATA(insert OID = 974 ("=" PGNSP PGUID b f t 1033 1033 16 974 0 aclitemeq eqsel eqjoinsel));
DESCR("equal");
/* additional geometric operators - thomas 1997-07-09 */
DATA(insert OID = 969 ("@@" PGNSP PGUID l f f 0 601 600 0 0 lseg_center - -));
DESCR("center of");
DATA(insert OID = 970 ("@@" PGNSP PGUID l f f 0 602 600 0 0 path_center - -));
DESCR("center of");
DATA(insert OID = 971 ("@@" PGNSP PGUID l f f 0 604 600 0 0 poly_center - -));
DESCR("center of");
DATA(insert OID = 1054 ("=" PGNSP PGUID b t t 1042 1042 16 1054 1057 bpchareq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1055 ("~" PGNSP PGUID b f f 1042 25 16 0 1056 bpcharregexeq regexeqsel regexeqjoinsel));
DESCR("matches regular expression, case-sensitive");
DATA(insert OID = 1056 ("!~" PGNSP PGUID b f f 1042 25 16 0 1055 bpcharregexne regexnesel regexnejoinsel));
DESCR("does not match regular expression, case-sensitive");
DATA(insert OID = 1057 ("<>" PGNSP PGUID b f f 1042 1042 16 1057 1054 bpcharne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1058 ("<" PGNSP PGUID b f f 1042 1042 16 1060 1061 bpcharlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1059 ("<=" PGNSP PGUID b f f 1042 1042 16 1061 1060 bpcharle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1060 (">" PGNSP PGUID b f f 1042 1042 16 1058 1059 bpchargt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1061 (">=" PGNSP PGUID b f f 1042 1042 16 1059 1058 bpcharge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* generic array comparison operators */
DATA(insert OID = 1070 ("=" PGNSP PGUID b t t 2277 2277 16 1070 1071 array_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1071 ("<>" PGNSP PGUID b f f 2277 2277 16 1071 1070 array_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1072 ("<" PGNSP PGUID b f f 2277 2277 16 1073 1075 array_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1073 (">" PGNSP PGUID b f f 2277 2277 16 1072 1074 array_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1074 ("<=" PGNSP PGUID b f f 2277 2277 16 1075 1073 array_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1075 (">=" PGNSP PGUID b f f 2277 2277 16 1074 1072 array_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* date operators */
DATA(insert OID = 1076 ("+" PGNSP PGUID b f f 1082 1186 1114 2551 0 date_pl_interval - -));
DESCR("add");
DATA(insert OID = 1077 ("-" PGNSP PGUID b f f 1082 1186 1114 0 0 date_mi_interval - -));
DESCR("subtract");
DATA(insert OID = 1093 ("=" PGNSP PGUID b t t 1082 1082 16 1093 1094 date_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1094 ("<>" PGNSP PGUID b f f 1082 1082 16 1094 1093 date_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1095 ("<" PGNSP PGUID b f f 1082 1082 16 1097 1098 date_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1096 ("<=" PGNSP PGUID b f f 1082 1082 16 1098 1097 date_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1097 (">" PGNSP PGUID b f f 1082 1082 16 1095 1096 date_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1098 (">=" PGNSP PGUID b f f 1082 1082 16 1096 1095 date_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1099 ("-" PGNSP PGUID b f f 1082 1082 23 0 0 date_mi - -));
DESCR("subtract");
DATA(insert OID = 1100 ("+" PGNSP PGUID b f f 1082 23 1082 2555 0 date_pli - -));
DESCR("add");
DATA(insert OID = 1101 ("-" PGNSP PGUID b f f 1082 23 1082 0 0 date_mii - -));
DESCR("subtract");
/* time operators */
DATA(insert OID = 1108 ("=" PGNSP PGUID b t t 1083 1083 16 1108 1109 time_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1109 ("<>" PGNSP PGUID b f f 1083 1083 16 1109 1108 time_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1110 ("<" PGNSP PGUID b f f 1083 1083 16 1112 1113 time_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1111 ("<=" PGNSP PGUID b f f 1083 1083 16 1113 1112 time_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1112 (">" PGNSP PGUID b f f 1083 1083 16 1110 1111 time_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1113 (">=" PGNSP PGUID b f f 1083 1083 16 1111 1110 time_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* timetz operators */
DATA(insert OID = 1550 ("=" PGNSP PGUID b t t 1266 1266 16 1550 1551 timetz_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1551 ("<>" PGNSP PGUID b f f 1266 1266 16 1551 1550 timetz_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1552 ("<" PGNSP PGUID b f f 1266 1266 16 1554 1555 timetz_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1553 ("<=" PGNSP PGUID b f f 1266 1266 16 1555 1554 timetz_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1554 (">" PGNSP PGUID b f f 1266 1266 16 1552 1553 timetz_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1555 (">=" PGNSP PGUID b f f 1266 1266 16 1553 1552 timetz_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* float48 operators */
DATA(insert OID = 1116 ("+" PGNSP PGUID b f f 700 701 701 1126 0 float48pl - -));
DESCR("add");
DATA(insert OID = 1117 ("-" PGNSP PGUID b f f 700 701 701 0 0 float48mi - -));
DESCR("subtract");
DATA(insert OID = 1118 ("/" PGNSP PGUID b f f 700 701 701 0 0 float48div - -));
DESCR("divide");
DATA(insert OID = 1119 ("*" PGNSP PGUID b f f 700 701 701 1129 0 float48mul - -));
DESCR("multiply");
DATA(insert OID = 1120 ("=" PGNSP PGUID b t t 700 701 16 1130 1121 float48eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1121 ("<>" PGNSP PGUID b f f 700 701 16 1131 1120 float48ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1122 ("<" PGNSP PGUID b f f 700 701 16 1133 1125 float48lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1123 (">" PGNSP PGUID b f f 700 701 16 1132 1124 float48gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1124 ("<=" PGNSP PGUID b f f 700 701 16 1135 1123 float48le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1125 (">=" PGNSP PGUID b f f 700 701 16 1134 1122 float48ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* float84 operators */
DATA(insert OID = 1126 ("+" PGNSP PGUID b f f 701 700 701 1116 0 float84pl - -));
DESCR("add");
DATA(insert OID = 1127 ("-" PGNSP PGUID b f f 701 700 701 0 0 float84mi - -));
DESCR("subtract");
DATA(insert OID = 1128 ("/" PGNSP PGUID b f f 701 700 701 0 0 float84div - -));
DESCR("divide");
DATA(insert OID = 1129 ("*" PGNSP PGUID b f f 701 700 701 1119 0 float84mul - -));
DESCR("multiply");
DATA(insert OID = 1130 ("=" PGNSP PGUID b t t 701 700 16 1120 1131 float84eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1131 ("<>" PGNSP PGUID b f f 701 700 16 1121 1130 float84ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1132 ("<" PGNSP PGUID b f f 701 700 16 1123 1135 float84lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1133 (">" PGNSP PGUID b f f 701 700 16 1122 1134 float84gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1134 ("<=" PGNSP PGUID b f f 701 700 16 1125 1133 float84le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1135 (">=" PGNSP PGUID b f f 701 700 16 1124 1132 float84ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* LIKE hacks by Keith Parks. */
DATA(insert OID = 1207 ("~~" PGNSP PGUID b f f 19 25 16 0 1208 namelike likesel likejoinsel));
DESCR("matches LIKE expression");
DATA(insert OID = 1208 ("!~~" PGNSP PGUID b f f 19 25 16 0 1207 namenlike nlikesel nlikejoinsel));
DESCR("does not match LIKE expression");
DATA(insert OID = 1209 ("~~" PGNSP PGUID b f f 25 25 16 0 1210 textlike likesel likejoinsel));
DESCR("matches LIKE expression");
DATA(insert OID = 1210 ("!~~" PGNSP PGUID b f f 25 25 16 0 1209 textnlike nlikesel nlikejoinsel));
DESCR("does not match LIKE expression");
DATA(insert OID = 1211 ("~~" PGNSP PGUID b f f 1042 25 16 0 1212 bpcharlike likesel likejoinsel));
DESCR("matches LIKE expression");
DATA(insert OID = 1212 ("!~~" PGNSP PGUID b f f 1042 25 16 0 1211 bpcharnlike nlikesel nlikejoinsel));
DESCR("does not match LIKE expression");
/* case-insensitive regex hacks */
DATA(insert OID = 1226 ("~*" PGNSP PGUID b f f 19 25 16 0 1227 nameicregexeq icregexeqsel icregexeqjoinsel));
DESCR("matches regular expression, case-insensitive");
DATA(insert OID = 1227 ("!~*" PGNSP PGUID b f f 19 25 16 0 1226 nameicregexne icregexnesel icregexnejoinsel));
DESCR("does not match regular expression, case-insensitive");
DATA(insert OID = 1228 ("~*" PGNSP PGUID b f f 25 25 16 0 1229 texticregexeq icregexeqsel icregexeqjoinsel));
DESCR("matches regular expression, case-insensitive");
DATA(insert OID = 1229 ("!~*" PGNSP PGUID b f f 25 25 16 0 1228 texticregexne icregexnesel icregexnejoinsel));
DESCR("does not match regular expression, case-insensitive");
DATA(insert OID = 1234 ("~*" PGNSP PGUID b f f 1042 25 16 0 1235 bpcharicregexeq icregexeqsel icregexeqjoinsel));
DESCR("matches regular expression, case-insensitive");
DATA(insert OID = 1235 ("!~*" PGNSP PGUID b f f 1042 25 16 0 1234 bpcharicregexne icregexnesel icregexnejoinsel));
DESCR("does not match regular expression, case-insensitive");
/* timestamptz operators */
DATA(insert OID = 1320 ("=" PGNSP PGUID b t t 1184 1184 16 1320 1321 timestamptz_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1321 ("<>" PGNSP PGUID b f f 1184 1184 16 1321 1320 timestamptz_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1322 ("<" PGNSP PGUID b f f 1184 1184 16 1324 1325 timestamptz_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1323 ("<=" PGNSP PGUID b f f 1184 1184 16 1325 1324 timestamptz_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1324 (">" PGNSP PGUID b f f 1184 1184 16 1322 1323 timestamptz_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1325 (">=" PGNSP PGUID b f f 1184 1184 16 1323 1322 timestamptz_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1327 ("+" PGNSP PGUID b f f 1184 1186 1184 2554 0 timestamptz_pl_interval - -));
DESCR("add");
DATA(insert OID = 1328 ("-" PGNSP PGUID b f f 1184 1184 1186 0 0 timestamptz_mi - -));
DESCR("subtract");
DATA(insert OID = 1329 ("-" PGNSP PGUID b f f 1184 1186 1184 0 0 timestamptz_mi_interval - -));
DESCR("subtract");
/* interval operators */
DATA(insert OID = 1330 ("=" PGNSP PGUID b t t 1186 1186 16 1330 1331 interval_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1331 ("<>" PGNSP PGUID b f f 1186 1186 16 1331 1330 interval_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1332 ("<" PGNSP PGUID b f f 1186 1186 16 1334 1335 interval_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1333 ("<=" PGNSP PGUID b f f 1186 1186 16 1335 1334 interval_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1334 (">" PGNSP PGUID b f f 1186 1186 16 1332 1333 interval_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1335 (">=" PGNSP PGUID b f f 1186 1186 16 1333 1332 interval_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1336 ("-" PGNSP PGUID l f f 0 1186 1186 0 0 interval_um - -));
DESCR("negate");
DATA(insert OID = 1337 ("+" PGNSP PGUID b f f 1186 1186 1186 1337 0 interval_pl - -));
DESCR("add");
DATA(insert OID = 1338 ("-" PGNSP PGUID b f f 1186 1186 1186 0 0 interval_mi - -));
DESCR("subtract");
DATA(insert OID = 1360 ("+" PGNSP PGUID b f f 1082 1083 1114 1363 0 datetime_pl - -));
DESCR("convert date and time to timestamp");
DATA(insert OID = 1361 ("+" PGNSP PGUID b f f 1082 1266 1184 1366 0 datetimetz_pl - -));
DESCR("convert date and time with time zone to timestamp with time zone");
DATA(insert OID = 1363 ("+" PGNSP PGUID b f f 1083 1082 1114 1360 0 timedate_pl - -));
DESCR("convert time and date to timestamp");
DATA(insert OID = 1366 ("+" PGNSP PGUID b f f 1266 1082 1184 1361 0 timetzdate_pl - -));
DESCR("convert time with time zone and date to timestamp with time zone");
DATA(insert OID = 1399 ("-" PGNSP PGUID b f f 1083 1083 1186 0 0 time_mi_time - -));
DESCR("subtract");
/* additional geometric operators - thomas 97/04/18 */
DATA(insert OID = 1420 ("@@" PGNSP PGUID l f f 0 718 600 0 0 circle_center - -));
DESCR("center of");
DATA(insert OID = 1500 ("=" PGNSP PGUID b f f 718 718 16 1500 1501 circle_eq eqsel eqjoinsel));
DESCR("equal by area");
DATA(insert OID = 1501 ("<>" PGNSP PGUID b f f 718 718 16 1501 1500 circle_ne neqsel neqjoinsel));
DESCR("not equal by area");
DATA(insert OID = 1502 ("<" PGNSP PGUID b f f 718 718 16 1503 1505 circle_lt areasel areajoinsel));
DESCR("less than by area");
DATA(insert OID = 1503 (">" PGNSP PGUID b f f 718 718 16 1502 1504 circle_gt areasel areajoinsel));
DESCR("greater than by area");
DATA(insert OID = 1504 ("<=" PGNSP PGUID b f f 718 718 16 1505 1503 circle_le areasel areajoinsel));
DESCR("less than or equal by area");
DATA(insert OID = 1505 (">=" PGNSP PGUID b f f 718 718 16 1504 1502 circle_ge areasel areajoinsel));
DESCR("greater than or equal by area");
DATA(insert OID = 1506 ("<<" PGNSP PGUID b f f 718 718 16 0 0 circle_left positionsel positionjoinsel));
DESCR("is left of");
DATA(insert OID = 1507 ("&<" PGNSP PGUID b f f 718 718 16 0 0 circle_overleft positionsel positionjoinsel));
DESCR("overlaps or is left of");
DATA(insert OID = 1508 ("&>" PGNSP PGUID b f f 718 718 16 0 0 circle_overright positionsel positionjoinsel));
DESCR("overlaps or is right of");
DATA(insert OID = 1509 (">>" PGNSP PGUID b f f 718 718 16 0 0 circle_right positionsel positionjoinsel));
DESCR("is right of");
DATA(insert OID = 1510 ("<@" PGNSP PGUID b f f 718 718 16 1511 0 circle_contained contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 1511 ("@>" PGNSP PGUID b f f 718 718 16 1510 0 circle_contain contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 1512 ("~=" PGNSP PGUID b f f 718 718 16 1512 0 circle_same eqsel eqjoinsel));
DESCR("same as");
DATA(insert OID = 1513 ("&&" PGNSP PGUID b f f 718 718 16 1513 0 circle_overlap areasel areajoinsel));
DESCR("overlaps");
DATA(insert OID = 1514 ("|>>" PGNSP PGUID b f f 718 718 16 0 0 circle_above positionsel positionjoinsel));
DESCR("is above");
DATA(insert OID = 1515 ("<<|" PGNSP PGUID b f f 718 718 16 0 0 circle_below positionsel positionjoinsel));
DESCR("is below");
DATA(insert OID = 1516 ("+" PGNSP PGUID b f f 718 600 718 0 0 circle_add_pt - -));
DESCR("add");
DATA(insert OID = 1517 ("-" PGNSP PGUID b f f 718 600 718 0 0 circle_sub_pt - -));
DESCR("subtract");
DATA(insert OID = 1518 ("*" PGNSP PGUID b f f 718 600 718 0 0 circle_mul_pt - -));
DESCR("multiply");
DATA(insert OID = 1519 ("/" PGNSP PGUID b f f 718 600 718 0 0 circle_div_pt - -));
DESCR("divide");
DATA(insert OID = 1520 ("<->" PGNSP PGUID b f f 718 718 701 1520 0 circle_distance - -));
DESCR("distance between");
DATA(insert OID = 1521 ("#" PGNSP PGUID l f f 0 604 23 0 0 poly_npoints - -));
DESCR("number of points");
DATA(insert OID = 1522 ("<->" PGNSP PGUID b f f 600 718 701 0 0 dist_pc - -));
DESCR("distance between");
DATA(insert OID = 1523 ("<->" PGNSP PGUID b f f 718 604 701 0 0 dist_cpoly - -));
DESCR("distance between");
/* additional geometric operators - thomas 1997-07-09 */
DATA(insert OID = 1524 ("<->" PGNSP PGUID b f f 628 603 701 0 0 dist_lb - -));
DESCR("distance between");
DATA(insert OID = 1525 ("?#" PGNSP PGUID b f f 601 601 16 1525 0 lseg_intersect - -));
DESCR("intersect");
DATA(insert OID = 1526 ("?||" PGNSP PGUID b f f 601 601 16 1526 0 lseg_parallel - -));
DESCR("parallel");
DATA(insert OID = 1527 ("?-|" PGNSP PGUID b f f 601 601 16 1527 0 lseg_perp - -));
DESCR("perpendicular");
DATA(insert OID = 1528 ("?-" PGNSP PGUID l f f 0 601 16 0 0 lseg_horizontal - -));
DESCR("horizontal");
DATA(insert OID = 1529 ("?|" PGNSP PGUID l f f 0 601 16 0 0 lseg_vertical - -));
DESCR("vertical");
DATA(insert OID = 1535 ("=" PGNSP PGUID b f f 601 601 16 1535 1586 lseg_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1536 ("#" PGNSP PGUID b f f 601 601 600 1536 0 lseg_interpt - -));
DESCR("intersection point");
DATA(insert OID = 1537 ("?#" PGNSP PGUID b f f 601 628 16 0 0 inter_sl - -));
DESCR("intersect");
DATA(insert OID = 1538 ("?#" PGNSP PGUID b f f 601 603 16 0 0 inter_sb - -));
DESCR("intersect");
DATA(insert OID = 1539 ("?#" PGNSP PGUID b f f 628 603 16 0 0 inter_lb - -));
DESCR("intersect");
DATA(insert OID = 1546 ("<@" PGNSP PGUID b f f 600 628 16 0 0 on_pl - -));
DESCR("point on line");
DATA(insert OID = 1547 ("<@" PGNSP PGUID b f f 600 601 16 0 0 on_ps - -));
DESCR("is contained by");
DATA(insert OID = 1548 ("<@" PGNSP PGUID b f f 601 628 16 0 0 on_sl - -));
DESCR("lseg on line");
DATA(insert OID = 1549 ("<@" PGNSP PGUID b f f 601 603 16 0 0 on_sb - -));
DESCR("is contained by");
DATA(insert OID = 1557 ("##" PGNSP PGUID b f f 600 628 600 0 0 close_pl - -));
DESCR("closest point to A on B");
DATA(insert OID = 1558 ("##" PGNSP PGUID b f f 600 601 600 0 0 close_ps - -));
DESCR("closest point to A on B");
DATA(insert OID = 1559 ("##" PGNSP PGUID b f f 600 603 600 0 0 close_pb - -));
DESCR("closest point to A on B");
DATA(insert OID = 1566 ("##" PGNSP PGUID b f f 601 628 600 0 0 close_sl - -));
DESCR("closest point to A on B");
DATA(insert OID = 1567 ("##" PGNSP PGUID b f f 601 603 600 0 0 close_sb - -));
DESCR("closest point to A on B");
DATA(insert OID = 1568 ("##" PGNSP PGUID b f f 628 603 600 0 0 close_lb - -));
DESCR("closest point to A on B");
DATA(insert OID = 1577 ("##" PGNSP PGUID b f f 628 601 600 0 0 close_ls - -));
DESCR("closest point to A on B");
DATA(insert OID = 1578 ("##" PGNSP PGUID b f f 601 601 600 0 0 close_lseg - -));
DESCR("closest point to A on B");
DATA(insert OID = 1583 ("*" PGNSP PGUID b f f 1186 701 1186 1584 0 interval_mul - -));
DESCR("multiply");
DATA(insert OID = 1584 ("*" PGNSP PGUID b f f 701 1186 1186 1583 0 mul_d_interval - -));
DESCR("multiply");
DATA(insert OID = 1585 ("/" PGNSP PGUID b f f 1186 701 1186 0 0 interval_div - -));
DESCR("divide");
DATA(insert OID = 1586 ("<>" PGNSP PGUID b f f 601 601 16 1586 1535 lseg_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1587 ("<" PGNSP PGUID b f f 601 601 16 1589 1590 lseg_lt - -));
DESCR("less than by length");
DATA(insert OID = 1588 ("<=" PGNSP PGUID b f f 601 601 16 1590 1589 lseg_le - -));
DESCR("less than or equal by length");
DATA(insert OID = 1589 (">" PGNSP PGUID b f f 601 601 16 1587 1588 lseg_gt - -));
DESCR("greater than by length");
DATA(insert OID = 1590 (">=" PGNSP PGUID b f f 601 601 16 1588 1587 lseg_ge - -));
DESCR("greater than or equal by length");
DATA(insert OID = 1591 ("@-@" PGNSP PGUID l f f 0 601 701 0 0 lseg_length - -));
DESCR("distance between endpoints");
DATA(insert OID = 1611 ("?#" PGNSP PGUID b f f 628 628 16 1611 0 line_intersect - -));
DESCR("intersect");
DATA(insert OID = 1612 ("?||" PGNSP PGUID b f f 628 628 16 1612 0 line_parallel - -));
DESCR("parallel");
DATA(insert OID = 1613 ("?-|" PGNSP PGUID b f f 628 628 16 1613 0 line_perp - -));
DESCR("perpendicular");
DATA(insert OID = 1614 ("?-" PGNSP PGUID l f f 0 628 16 0 0 line_horizontal - -));
DESCR("horizontal");
DATA(insert OID = 1615 ("?|" PGNSP PGUID l f f 0 628 16 0 0 line_vertical - -));
DESCR("vertical");
DATA(insert OID = 1616 ("=" PGNSP PGUID b f f 628 628 16 1616 0 line_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1617 ("#" PGNSP PGUID b f f 628 628 600 1617 0 line_interpt - -));
DESCR("intersection point");
/* MAC type */
DATA(insert OID = 1220 ("=" PGNSP PGUID b t t 829 829 16 1220 1221 macaddr_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1221 ("<>" PGNSP PGUID b f f 829 829 16 1221 1220 macaddr_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1222 ("<" PGNSP PGUID b f f 829 829 16 1224 1225 macaddr_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1223 ("<=" PGNSP PGUID b f f 829 829 16 1225 1224 macaddr_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1224 (">" PGNSP PGUID b f f 829 829 16 1222 1223 macaddr_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1225 (">=" PGNSP PGUID b f f 829 829 16 1223 1222 macaddr_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 3147 ("~" PGNSP PGUID l f f 0 829 829 0 0 macaddr_not - -));
DESCR("bitwise not");
DATA(insert OID = 3148 ("&" PGNSP PGUID b f f 829 829 829 0 0 macaddr_and - -));
DESCR("bitwise and");
DATA(insert OID = 3149 ("|" PGNSP PGUID b f f 829 829 829 0 0 macaddr_or - -));
DESCR("bitwise or");
/* INET type (these also support CIDR via implicit cast) */
DATA(insert OID = 1201 ("=" PGNSP PGUID b t t 869 869 16 1201 1202 network_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1202 ("<>" PGNSP PGUID b f f 869 869 16 1202 1201 network_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1203 ("<" PGNSP PGUID b f f 869 869 16 1205 1206 network_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1204 ("<=" PGNSP PGUID b f f 869 869 16 1206 1205 network_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1205 (">" PGNSP PGUID b f f 869 869 16 1203 1204 network_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1206 (">=" PGNSP PGUID b f f 869 869 16 1204 1203 network_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 931 ("<<" PGNSP PGUID b f f 869 869 16 933 0 network_sub - -));
DESCR("is subnet");
DATA(insert OID = 932 ("<<=" PGNSP PGUID b f f 869 869 16 934 0 network_subeq - -));
DESCR("is subnet or equal");
DATA(insert OID = 933 (">>" PGNSP PGUID b f f 869 869 16 931 0 network_sup - -));
DESCR("is supernet");
DATA(insert OID = 934 (">>=" PGNSP PGUID b f f 869 869 16 932 0 network_supeq - -));
DESCR("is supernet or equal");
DATA(insert OID = 2634 ("~" PGNSP PGUID l f f 0 869 869 0 0 inetnot - -));
DESCR("bitwise not");
DATA(insert OID = 2635 ("&" PGNSP PGUID b f f 869 869 869 0 0 inetand - -));
DESCR("bitwise and");
DATA(insert OID = 2636 ("|" PGNSP PGUID b f f 869 869 869 0 0 inetor - -));
DESCR("bitwise or");
DATA(insert OID = 2637 ("+" PGNSP PGUID b f f 869 20 869 2638 0 inetpl - -));
DESCR("add");
DATA(insert OID = 2638 ("+" PGNSP PGUID b f f 20 869 869 2637 0 int8pl_inet - -));
DESCR("add");
DATA(insert OID = 2639 ("-" PGNSP PGUID b f f 869 20 869 0 0 inetmi_int8 - -));
DESCR("subtract");
DATA(insert OID = 2640 ("-" PGNSP PGUID b f f 869 869 20 0 0 inetmi - -));
DESCR("subtract");
/* case-insensitive LIKE hacks */
DATA(insert OID = 1625 ("~~*" PGNSP PGUID b f f 19 25 16 0 1626 nameiclike iclikesel iclikejoinsel));
DESCR("matches LIKE expression, case-insensitive");
DATA(insert OID = 1626 ("!~~*" PGNSP PGUID b f f 19 25 16 0 1625 nameicnlike icnlikesel icnlikejoinsel));
DESCR("does not match LIKE expression, case-insensitive");
DATA(insert OID = 1627 ("~~*" PGNSP PGUID b f f 25 25 16 0 1628 texticlike iclikesel iclikejoinsel));
DESCR("matches LIKE expression, case-insensitive");
DATA(insert OID = 1628 ("!~~*" PGNSP PGUID b f f 25 25 16 0 1627 texticnlike icnlikesel icnlikejoinsel));
DESCR("does not match LIKE expression, case-insensitive");
DATA(insert OID = 1629 ("~~*" PGNSP PGUID b f f 1042 25 16 0 1630 bpchariclike iclikesel iclikejoinsel));
DESCR("matches LIKE expression, case-insensitive");
DATA(insert OID = 1630 ("!~~*" PGNSP PGUID b f f 1042 25 16 0 1629 bpcharicnlike icnlikesel icnlikejoinsel));
DESCR("does not match LIKE expression, case-insensitive");
/* NUMERIC type - OID's 1700-1799 */
DATA(insert OID = 1751 ("-" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_uminus - -));
DESCR("negate");
DATA(insert OID = 1752 ("=" PGNSP PGUID b t t 1700 1700 16 1752 1753 numeric_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1753 ("<>" PGNSP PGUID b f f 1700 1700 16 1753 1752 numeric_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1754 ("<" PGNSP PGUID b f f 1700 1700 16 1756 1757 numeric_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1755 ("<=" PGNSP PGUID b f f 1700 1700 16 1757 1756 numeric_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1756 (">" PGNSP PGUID b f f 1700 1700 16 1754 1755 numeric_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1757 (">=" PGNSP PGUID b f f 1700 1700 16 1755 1754 numeric_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1758 ("+" PGNSP PGUID b f f 1700 1700 1700 1758 0 numeric_add - -));
DESCR("add");
DATA(insert OID = 1759 ("-" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_sub - -));
DESCR("subtract");
DATA(insert OID = 1760 ("*" PGNSP PGUID b f f 1700 1700 1700 1760 0 numeric_mul - -));
DESCR("multiply");
DATA(insert OID = 1761 ("/" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_div - -));
DESCR("divide");
DATA(insert OID = 1762 ("%" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_mod - -));
DESCR("modulus");
DATA(insert OID = 1038 ("^" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_power - -));
DESCR("exponentiation");
DATA(insert OID = 1763 ("@" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_abs - -));
DESCR("absolute value");
DATA(insert OID = 1784 ("=" PGNSP PGUID b t f 1560 1560 16 1784 1785 biteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1785 ("<>" PGNSP PGUID b f f 1560 1560 16 1785 1784 bitne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1786 ("<" PGNSP PGUID b f f 1560 1560 16 1787 1789 bitlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1787 (">" PGNSP PGUID b f f 1560 1560 16 1786 1788 bitgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1788 ("<=" PGNSP PGUID b f f 1560 1560 16 1789 1787 bitle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1789 (">=" PGNSP PGUID b f f 1560 1560 16 1788 1786 bitge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1791 ("&" PGNSP PGUID b f f 1560 1560 1560 1791 0 bitand - -));
DESCR("bitwise and");
DATA(insert OID = 1792 ("|" PGNSP PGUID b f f 1560 1560 1560 1792 0 bitor - -));
DESCR("bitwise or");
DATA(insert OID = 1793 ("#" PGNSP PGUID b f f 1560 1560 1560 1793 0 bitxor - -));
DESCR("bitwise exclusive or");
DATA(insert OID = 1794 ("~" PGNSP PGUID l f f 0 1560 1560 0 0 bitnot - -));
DESCR("bitwise not");
DATA(insert OID = 1795 ("<<" PGNSP PGUID b f f 1560 23 1560 0 0 bitshiftleft - -));
DESCR("bitwise shift left");
DATA(insert OID = 1796 (">>" PGNSP PGUID b f f 1560 23 1560 0 0 bitshiftright - -));
DESCR("bitwise shift right");
DATA(insert OID = 1797 ("||" PGNSP PGUID b f f 1562 1562 1562 0 0 bitcat - -));
DESCR("concatenate");
DATA(insert OID = 1800 ("+" PGNSP PGUID b f f 1083 1186 1083 1849 0 time_pl_interval - -));
DESCR("add");
DATA(insert OID = 1801 ("-" PGNSP PGUID b f f 1083 1186 1083 0 0 time_mi_interval - -));
DESCR("subtract");
DATA(insert OID = 1802 ("+" PGNSP PGUID b f f 1266 1186 1266 2552 0 timetz_pl_interval - -));
DESCR("add");
DATA(insert OID = 1803 ("-" PGNSP PGUID b f f 1266 1186 1266 0 0 timetz_mi_interval - -));
DESCR("subtract");
DATA(insert OID = 1804 ("=" PGNSP PGUID b t f 1562 1562 16 1804 1805 varbiteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1805 ("<>" PGNSP PGUID b f f 1562 1562 16 1805 1804 varbitne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1806 ("<" PGNSP PGUID b f f 1562 1562 16 1807 1809 varbitlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1807 (">" PGNSP PGUID b f f 1562 1562 16 1806 1808 varbitgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1808 ("<=" PGNSP PGUID b f f 1562 1562 16 1809 1807 varbitle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1809 (">=" PGNSP PGUID b f f 1562 1562 16 1808 1806 varbitge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1849 ("+" PGNSP PGUID b f f 1186 1083 1083 1800 0 interval_pl_time - -));
DESCR("add");
DATA(insert OID = 1862 ("=" PGNSP PGUID b t t 21 20 16 1868 1863 int28eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1863 ("<>" PGNSP PGUID b f f 21 20 16 1869 1862 int28ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1864 ("<" PGNSP PGUID b f f 21 20 16 1871 1867 int28lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1865 (">" PGNSP PGUID b f f 21 20 16 1870 1866 int28gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1866 ("<=" PGNSP PGUID b f f 21 20 16 1873 1865 int28le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1867 (">=" PGNSP PGUID b f f 21 20 16 1872 1864 int28ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1868 ("=" PGNSP PGUID b t t 20 21 16 1862 1869 int82eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1869 ("<>" PGNSP PGUID b f f 20 21 16 1863 1868 int82ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1870 ("<" PGNSP PGUID b f f 20 21 16 1865 1873 int82lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1871 (">" PGNSP PGUID b f f 20 21 16 1864 1872 int82gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1872 ("<=" PGNSP PGUID b f f 20 21 16 1867 1871 int82le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1873 (">=" PGNSP PGUID b f f 20 21 16 1866 1870 int82ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 1874 ("&" PGNSP PGUID b f f 21 21 21 1874 0 int2and - -));
DESCR("bitwise and");
DATA(insert OID = 1875 ("|" PGNSP PGUID b f f 21 21 21 1875 0 int2or - -));
DESCR("bitwise or");
DATA(insert OID = 1876 ("#" PGNSP PGUID b f f 21 21 21 1876 0 int2xor - -));
DESCR("bitwise exclusive or");
DATA(insert OID = 1877 ("~" PGNSP PGUID l f f 0 21 21 0 0 int2not - -));
DESCR("bitwise not");
DATA(insert OID = 1878 ("<<" PGNSP PGUID b f f 21 23 21 0 0 int2shl - -));
DESCR("bitwise shift left");
DATA(insert OID = 1879 (">>" PGNSP PGUID b f f 21 23 21 0 0 int2shr - -));
DESCR("bitwise shift right");
DATA(insert OID = 1880 ("&" PGNSP PGUID b f f 23 23 23 1880 0 int4and - -));
DESCR("bitwise and");
DATA(insert OID = 1881 ("|" PGNSP PGUID b f f 23 23 23 1881 0 int4or - -));
DESCR("bitwise or");
DATA(insert OID = 1882 ("#" PGNSP PGUID b f f 23 23 23 1882 0 int4xor - -));
DESCR("bitwise exclusive or");
DATA(insert OID = 1883 ("~" PGNSP PGUID l f f 0 23 23 0 0 int4not - -));
DESCR("bitwise not");
DATA(insert OID = 1884 ("<<" PGNSP PGUID b f f 23 23 23 0 0 int4shl - -));
DESCR("bitwise shift left");
DATA(insert OID = 1885 (">>" PGNSP PGUID b f f 23 23 23 0 0 int4shr - -));
DESCR("bitwise shift right");
DATA(insert OID = 1886 ("&" PGNSP PGUID b f f 20 20 20 1886 0 int8and - -));
DESCR("bitwise and");
DATA(insert OID = 1887 ("|" PGNSP PGUID b f f 20 20 20 1887 0 int8or - -));
DESCR("bitwise or");
DATA(insert OID = 1888 ("#" PGNSP PGUID b f f 20 20 20 1888 0 int8xor - -));
DESCR("bitwise exclusive or");
DATA(insert OID = 1889 ("~" PGNSP PGUID l f f 0 20 20 0 0 int8not - -));
DESCR("bitwise not");
DATA(insert OID = 1890 ("<<" PGNSP PGUID b f f 20 23 20 0 0 int8shl - -));
DESCR("bitwise shift left");
DATA(insert OID = 1891 (">>" PGNSP PGUID b f f 20 23 20 0 0 int8shr - -));
DESCR("bitwise shift right");
DATA(insert OID = 1916 ("+" PGNSP PGUID l f f 0 20 20 0 0 int8up - -));
DESCR("unary plus");
DATA(insert OID = 1917 ("+" PGNSP PGUID l f f 0 21 21 0 0 int2up - -));
DESCR("unary plus");
DATA(insert OID = 1918 ("+" PGNSP PGUID l f f 0 23 23 0 0 int4up - -));
DESCR("unary plus");
DATA(insert OID = 1919 ("+" PGNSP PGUID l f f 0 700 700 0 0 float4up - -));
DESCR("unary plus");
DATA(insert OID = 1920 ("+" PGNSP PGUID l f f 0 701 701 0 0 float8up - -));
DESCR("unary plus");
DATA(insert OID = 1921 ("+" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_uplus - -));
DESCR("unary plus");
/* bytea operators */
DATA(insert OID = 1955 ("=" PGNSP PGUID b t t 17 17 16 1955 1956 byteaeq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 1956 ("<>" PGNSP PGUID b f f 17 17 16 1956 1955 byteane neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 1957 ("<" PGNSP PGUID b f f 17 17 16 1959 1960 bytealt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 1958 ("<=" PGNSP PGUID b f f 17 17 16 1960 1959 byteale scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 1959 (">" PGNSP PGUID b f f 17 17 16 1957 1958 byteagt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 1960 (">=" PGNSP PGUID b f f 17 17 16 1958 1957 byteage scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2016 ("~~" PGNSP PGUID b f f 17 17 16 0 2017 bytealike likesel likejoinsel));
DESCR("matches LIKE expression");
DATA(insert OID = 2017 ("!~~" PGNSP PGUID b f f 17 17 16 0 2016 byteanlike nlikesel nlikejoinsel));
DESCR("does not match LIKE expression");
DATA(insert OID = 2018 ("||" PGNSP PGUID b f f 17 17 17 0 0 byteacat - -));
DESCR("concatenate");
/* byteawithoutorderwithequalcol operators */
DATA(insert OID = 4453 ("=" PGNSP PGUID b t t 4402 4402 16 4453 4454 byteawithoutorderwithequalcoleq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 4454 ("<>" PGNSP PGUID b f f 4402 4402 16 4454 4453 byteawithoutorderwithequalcolne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 4422 ("=" PGNSP PGUID b f f 4402 17 16 4431 4423 byteawithoutorderwithequalcoleqbytear eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 4423 ("<>" PGNSP PGUID b f f 4402 17 16 4432 4422 byteawithoutorderwithequalcolnebytear neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 4431 ("=" PGNSP PGUID b f f 17 4402 16 4422 4432 byteawithoutorderwithequalcoleqbyteal eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 4432 ("<>" PGNSP PGUID b f f 17 4402 16 4423 4431 byteawithoutorderwithequalcolnebyteal neqsel neqjoinsel));
DESCR("not equal");
/* raw operators */
DATA(insert OID = 3798 ("=" PGNSP PGUID b t t 86 86 16 3798 3799 raweq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 3799 ("<>" PGNSP PGUID b f f 86 86 16 3799 3798 rawne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 3800 ("<" PGNSP PGUID b f f 86 86 16 3802 3803 rawlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 3801 ("<=" PGNSP PGUID b f f 86 86 16 3803 3802 rawle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 3802 (">" PGNSP PGUID b f f 86 86 16 3800 3801 rawgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 3803 (">=" PGNSP PGUID b f f 86 86 16 3801 3800 rawge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 3804 ("~~" PGNSP PGUID b f f 86 86 16 0 3805 rawlike likesel likejoinsel));
DESCR("matches like expression");
DATA(insert OID = 3805 ("!~~" PGNSP PGUID b f f 86 86 16 0 3804 rawnlike nlikesel nlikejoinsel));
DESCR("does not match like expression");
/* timestamp operators */
DATA(insert OID = 2060 ("=" PGNSP PGUID b t t 1114 1114 16 2060 2061 timestamp_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2061 ("<>" PGNSP PGUID b f f 1114 1114 16 2061 2060 timestamp_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2062 ("<" PGNSP PGUID b f f 1114 1114 16 2064 2065 timestamp_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2063 ("<=" PGNSP PGUID b f f 1114 1114 16 2065 2064 timestamp_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2064 (">" PGNSP PGUID b f f 1114 1114 16 2062 2063 timestamp_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2065 (">=" PGNSP PGUID b f f 1114 1114 16 2063 2062 timestamp_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2066 ("+" PGNSP PGUID b f f 1114 1186 1114 2553 0 timestamp_pl_interval - -));
DESCR("add");
DATA(insert OID = 2067 ("-" PGNSP PGUID b f f 1114 1114 1186 0 0 timestamp_mi - -));
DESCR("subtract");
DATA(insert OID = 2068 ("-" PGNSP PGUID b f f 1114 1186 1114 0 0 timestamp_mi_interval - -));
DESCR("subtract");
/* character-by-character (not collation order) comparison operators for character types */
DATA(insert OID = 2314 ("~<~" PGNSP PGUID b f f 25 25 16 2318 2317 text_pattern_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2315 ("~<=~" PGNSP PGUID b f f 25 25 16 2317 2318 text_pattern_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2317 ("~>=~" PGNSP PGUID b f f 25 25 16 2315 2314 text_pattern_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2318 ("~>~" PGNSP PGUID b f f 25 25 16 2314 2315 text_pattern_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2326 ("~<~" PGNSP PGUID b f f 1042 1042 16 2330 2329 bpchar_pattern_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2327 ("~<=~" PGNSP PGUID b f f 1042 1042 16 2329 2330 bpchar_pattern_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2329 ("~>=~" PGNSP PGUID b f f 1042 1042 16 2327 2326 bpchar_pattern_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2330 ("~>~" PGNSP PGUID b f f 1042 1042 16 2326 2327 bpchar_pattern_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
/* crosstype operations for date vs. timestamp and timestamptz */
DATA(insert OID = 2345 ("<" PGNSP PGUID b f f 1082 1114 16 2375 2348 date_lt_timestamp scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2346 ("<=" PGNSP PGUID b f f 1082 1114 16 2374 2349 date_le_timestamp scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2347 ("=" PGNSP PGUID b t f 1082 1114 16 2373 2350 date_eq_timestamp eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2348 (">=" PGNSP PGUID b f f 1082 1114 16 2372 2345 date_ge_timestamp scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2349 (">" PGNSP PGUID b f f 1082 1114 16 2371 2346 date_gt_timestamp scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2350 ("<>" PGNSP PGUID b f f 1082 1114 16 2376 2347 date_ne_timestamp neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2358 ("<" PGNSP PGUID b f f 1082 1184 16 2388 2361 date_lt_timestamptz scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2359 ("<=" PGNSP PGUID b f f 1082 1184 16 2387 2362 date_le_timestamptz scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2360 ("=" PGNSP PGUID b t f 1082 1184 16 2386 2363 date_eq_timestamptz eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2361 (">=" PGNSP PGUID b f f 1082 1184 16 2385 2358 date_ge_timestamptz scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2362 (">" PGNSP PGUID b f f 1082 1184 16 2384 2359 date_gt_timestamptz scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2363 ("<>" PGNSP PGUID b f f 1082 1184 16 2389 2360 date_ne_timestamptz neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2371 ("<" PGNSP PGUID b f f 1114 1082 16 2349 2374 timestamp_lt_date scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2372 ("<=" PGNSP PGUID b f f 1114 1082 16 2348 2375 timestamp_le_date scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2373 ("=" PGNSP PGUID b t f 1114 1082 16 2347 2376 timestamp_eq_date eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2374 (">=" PGNSP PGUID b f f 1114 1082 16 2346 2371 timestamp_ge_date scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2375 (">" PGNSP PGUID b f f 1114 1082 16 2345 2372 timestamp_gt_date scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2376 ("<>" PGNSP PGUID b f f 1114 1082 16 2350 2373 timestamp_ne_date neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2384 ("<" PGNSP PGUID b f f 1184 1082 16 2362 2387 timestamptz_lt_date scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2385 ("<=" PGNSP PGUID b f f 1184 1082 16 2361 2388 timestamptz_le_date scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2386 ("=" PGNSP PGUID b t f 1184 1082 16 2360 2389 timestamptz_eq_date eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2387 (">=" PGNSP PGUID b f f 1184 1082 16 2359 2384 timestamptz_ge_date scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2388 (">" PGNSP PGUID b f f 1184 1082 16 2358 2385 timestamptz_gt_date scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2389 ("<>" PGNSP PGUID b f f 1184 1082 16 2363 2386 timestamptz_ne_date neqsel neqjoinsel));
DESCR("not equal");
/* crosstype operations for timestamp vs. timestamptz */
DATA(insert OID = 2534 ("<" PGNSP PGUID b f f 1114 1184 16 2544 2537 timestamp_lt_timestamptz scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2535 ("<=" PGNSP PGUID b f f 1114 1184 16 2543 2538 timestamp_le_timestamptz scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2536 ("=" PGNSP PGUID b t f 1114 1184 16 2542 2539 timestamp_eq_timestamptz eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2537 (">=" PGNSP PGUID b f f 1114 1184 16 2541 2534 timestamp_ge_timestamptz scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2538 (">" PGNSP PGUID b f f 1114 1184 16 2540 2535 timestamp_gt_timestamptz scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2539 ("<>" PGNSP PGUID b f f 1114 1184 16 2545 2536 timestamp_ne_timestamptz neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2540 ("<" PGNSP PGUID b f f 1184 1114 16 2538 2543 timestamptz_lt_timestamp scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2541 ("<=" PGNSP PGUID b f f 1184 1114 16 2537 2544 timestamptz_le_timestamp scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2542 ("=" PGNSP PGUID b t f 1184 1114 16 2536 2545 timestamptz_eq_timestamp eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2543 (">=" PGNSP PGUID b f f 1184 1114 16 2535 2540 timestamptz_ge_timestamp scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 2544 (">" PGNSP PGUID b f f 1184 1114 16 2534 2541 timestamptz_gt_timestamp scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2545 ("<>" PGNSP PGUID b f f 1184 1114 16 2539 2542 timestamptz_ne_timestamp neqsel neqjoinsel));
DESCR("not equal");
/* formerly-missing interval + datetime operators */
DATA(insert OID = 2551 ("+" PGNSP PGUID b f f 1186 1082 1114 1076 0 interval_pl_date - -));
DESCR("add");
DATA(insert OID = 2552 ("+" PGNSP PGUID b f f 1186 1266 1266 1802 0 interval_pl_timetz - -));
DESCR("add");
DATA(insert OID = 2553 ("+" PGNSP PGUID b f f 1186 1114 1114 2066 0 interval_pl_timestamp - -));
DESCR("add");
DATA(insert OID = 2554 ("+" PGNSP PGUID b f f 1186 1184 1184 1327 0 interval_pl_timestamptz - -));
DESCR("add");
DATA(insert OID = 2555 ("+" PGNSP PGUID b f f 23 1082 1082 1100 0 integer_pl_date - -));
DESCR("add");
/* new operators for Y-direction rtree opfamilies */
DATA(insert OID = 2570 ("<<|" PGNSP PGUID b f f 603 603 16 0 0 box_below positionsel positionjoinsel));
DESCR("is below");
DATA(insert OID = 2571 ("&<|" PGNSP PGUID b f f 603 603 16 0 0 box_overbelow positionsel positionjoinsel));
DESCR("overlaps or is below");
DATA(insert OID = 2572 ("|&>" PGNSP PGUID b f f 603 603 16 0 0 box_overabove positionsel positionjoinsel));
DESCR("overlaps or is above");
DATA(insert OID = 2573 ("|>>" PGNSP PGUID b f f 603 603 16 0 0 box_above positionsel positionjoinsel));
DESCR("is above");
DATA(insert OID = 2574 ("<<|" PGNSP PGUID b f f 604 604 16 0 0 poly_below positionsel positionjoinsel));
DESCR("is below");
DATA(insert OID = 2575 ("&<|" PGNSP PGUID b f f 604 604 16 0 0 poly_overbelow positionsel positionjoinsel));
DESCR("overlaps or is below");
DATA(insert OID = 2576 ("|&>" PGNSP PGUID b f f 604 604 16 0 0 poly_overabove positionsel positionjoinsel));
DESCR("overlaps or is above");
DATA(insert OID = 2577 ("|>>" PGNSP PGUID b f f 604 604 16 0 0 poly_above positionsel positionjoinsel));
DESCR("is above");
DATA(insert OID = 2589 ("&<|" PGNSP PGUID b f f 718 718 16 0 0 circle_overbelow positionsel positionjoinsel));
DESCR("overlaps or is below");
DATA(insert OID = 2590 ("|&>" PGNSP PGUID b f f 718 718 16 0 0 circle_overabove positionsel positionjoinsel));
DESCR("overlaps or is above");
/* overlap/contains/contained for arrays */
DATA(insert OID = 2750 ("&&" PGNSP PGUID b f f 2277 2277 16 2750 0 arrayoverlap arraycontsel arraycontjoinsel));
DESCR("overlaps");
DATA(insert OID = 2751 ("@>" PGNSP PGUID b f f 2277 2277 16 2752 0 arraycontains arraycontsel arraycontjoinsel));
DESCR("contains");
DATA(insert OID = 2752 ("<@" PGNSP PGUID b f f 2277 2277 16 2751 0 arraycontained arraycontsel arraycontjoinsel));
DESCR("is contained by");
/* capturing operators to preserve pre-8.3 behavior of text concatenation */
DATA(insert OID = 2779 ("||" PGNSP PGUID b f f 25 2776 25 0 0 textanycat - -));
DESCR("concatenate");
DATA(insert OID = 2780 ("||" PGNSP PGUID b f f 2776 25 25 0 0 anytextcat - -));
DESCR("concatenate");
/* obsolete names for contains/contained-by operators; remove these someday */
DATA(insert OID = 2860 ("@" PGNSP PGUID b f f 604 604 16 2861 0 poly_contained contsel contjoinsel));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2861 ("~" PGNSP PGUID b f f 604 604 16 2860 0 poly_contain contsel contjoinsel));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2862 ("@" PGNSP PGUID b f f 603 603 16 2863 0 box_contained contsel contjoinsel));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2863 ("~" PGNSP PGUID b f f 603 603 16 2862 0 box_contain contsel contjoinsel));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2864 ("@" PGNSP PGUID b f f 718 718 16 2865 0 circle_contained contsel contjoinsel));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2865 ("~" PGNSP PGUID b f f 718 718 16 2864 0 circle_contain contsel contjoinsel));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2866 ("@" PGNSP PGUID b f f 600 603 16 0 0 on_pb - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2867 ("@" PGNSP PGUID b f f 600 602 16 2868 0 on_ppath - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2868 ("~" PGNSP PGUID b f f 602 600 16 2867 0 path_contain_pt - -));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2869 ("@" PGNSP PGUID b f f 600 604 16 2870 0 pt_contained_poly - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2870 ("~" PGNSP PGUID b f f 604 600 16 2869 0 poly_contain_pt - -));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2871 ("@" PGNSP PGUID b f f 600 718 16 2872 0 pt_contained_circle - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2872 ("~" PGNSP PGUID b f f 718 600 16 2871 0 circle_contain_pt - -));
DESCR("deprecated, use @> instead");
DATA(insert OID = 2873 ("@" PGNSP PGUID b f f 600 628 16 0 0 on_pl - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2874 ("@" PGNSP PGUID b f f 600 601 16 0 0 on_ps - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2875 ("@" PGNSP PGUID b f f 601 628 16 0 0 on_sl - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2876 ("@" PGNSP PGUID b f f 601 603 16 0 0 on_sb - -));
DESCR("deprecated, use <@ instead");
DATA(insert OID = 2877 ("~" PGNSP PGUID b f f 1034 1033 16 0 0 aclcontains - -));
DESCR("deprecated, use @> instead");
/* uuid operators */
DATA(insert OID = 2972 ("=" PGNSP PGUID b t t 2950 2950 16 2972 2973 uuid_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2973 ("<>" PGNSP PGUID b f f 2950 2950 16 2973 2972 uuid_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2974 ("<" PGNSP PGUID b f f 2950 2950 16 2975 2977 uuid_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2975 (">" PGNSP PGUID b f f 2950 2950 16 2974 2976 uuid_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2976 ("<=" PGNSP PGUID b f f 2950 2950 16 2977 2975 uuid_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2977 (">=" PGNSP PGUID b f f 2950 2950 16 2976 2974 uuid_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* enum operators */
DATA(insert OID = 3516 ("=" PGNSP PGUID b t t 3500 3500 16 3516 3517 enum_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 3517 ("<>" PGNSP PGUID b f f 3500 3500 16 3517 3516 enum_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 3518 ("<" PGNSP PGUID b f f 3500 3500 16 3519 3521 enum_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 3519 (">" PGNSP PGUID b f f 3500 3500 16 3518 3520 enum_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 3520 ("<=" PGNSP PGUID b f f 3500 3500 16 3521 3519 enum_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 3521 (">=" PGNSP PGUID b f f 3500 3500 16 3520 3518 enum_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/*
* tsearch operations
*/
DATA(insert OID = 3627 ("<" PGNSP PGUID b f f 3614 3614 16 3632 3631 tsvector_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 3628 ("<=" PGNSP PGUID b f f 3614 3614 16 3631 3632 tsvector_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 3629 ("=" PGNSP PGUID b t f 3614 3614 16 3629 3630 tsvector_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 3630 ("<>" PGNSP PGUID b f f 3614 3614 16 3630 3629 tsvector_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 3631 (">=" PGNSP PGUID b f f 3614 3614 16 3628 3627 tsvector_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 3632 (">" PGNSP PGUID b f f 3614 3614 16 3627 3628 tsvector_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 3633 ("||" PGNSP PGUID b f f 3614 3614 3614 0 0 tsvector_concat - -));
DESCR("concatenate");
DATA(insert OID = 3636 ("@@" PGNSP PGUID b f f 3614 3615 16 3637 0 ts_match_vq tsmatchsel tsmatchjoinsel));
DESCR("text search match");
DATA(insert OID = 3637 ("@@" PGNSP PGUID b f f 3615 3614 16 3636 0 ts_match_qv tsmatchsel tsmatchjoinsel));
DESCR("text search match");
DATA(insert OID = 3660 ("@@@" PGNSP PGUID b f f 3614 3615 16 3661 0 ts_match_vq tsmatchsel tsmatchjoinsel));
DESCR("deprecated, use @@ instead");
DATA(insert OID = 3661 ("@@@" PGNSP PGUID b f f 3615 3614 16 3660 0 ts_match_qv tsmatchsel tsmatchjoinsel));
DESCR("deprecated, use @@ instead");
DATA(insert OID = 3674 ("<" PGNSP PGUID b f f 3615 3615 16 3679 3678 tsquery_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 3675 ("<=" PGNSP PGUID b f f 3615 3615 16 3678 3679 tsquery_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 3676 ("=" PGNSP PGUID b t f 3615 3615 16 3676 3677 tsquery_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 3677 ("<>" PGNSP PGUID b f f 3615 3615 16 3677 3676 tsquery_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 3678 (">=" PGNSP PGUID b f f 3615 3615 16 3675 3674 tsquery_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 3679 (">" PGNSP PGUID b f f 3615 3615 16 3674 3675 tsquery_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 3680 ("&&" PGNSP PGUID b f f 3615 3615 3615 0 0 tsquery_and - -));
DESCR("AND-concatenate");
DATA(insert OID = 3681 ("||" PGNSP PGUID b f f 3615 3615 3615 0 0 tsquery_or - -));
DESCR("OR-concatenate");
DATA(insert OID = 3682 ("!!" PGNSP PGUID l f f 0 3615 3615 0 0 tsquery_not - -));
DESCR("NOT tsquery");
DATA(insert OID = 3693 ("@>" PGNSP PGUID b f f 3615 3615 16 3694 0 tsq_mcontains contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 3694 ("<@" PGNSP PGUID b f f 3615 3615 16 3693 0 tsq_mcontained contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 3762 ("@@" PGNSP PGUID b f f 25 25 16 0 0 ts_match_tt contsel contjoinsel));
DESCR("text search match");
DATA(insert OID = 3763 ("@@" PGNSP PGUID b f f 25 3615 16 0 0 ts_match_tq contsel contjoinsel));
DESCR("text search match");
/* generic record comparison operators */
DATA(insert OID = 2988 ("=" PGNSP PGUID b t f 2249 2249 16 2988 2989 record_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 2989 ("<>" PGNSP PGUID b f f 2249 2249 16 2989 2988 record_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 2990 ("<" PGNSP PGUID b f f 2249 2249 16 2991 2993 record_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 2991 (">" PGNSP PGUID b f f 2249 2249 16 2990 2992 record_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 2992 ("<=" PGNSP PGUID b f f 2249 2249 16 2993 2991 record_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 2993 (">=" PGNSP PGUID b f f 2249 2249 16 2992 2990 record_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* generic range type operators */
DATA(insert OID = 3882 ("=" PGNSP PGUID b t t 3831 3831 16 3882 3883 range_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 3883 ("<>" PGNSP PGUID b f f 3831 3831 16 3883 3882 range_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 3884 ("<" PGNSP PGUID b f f 3831 3831 16 3887 3886 range_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 3885 ("<=" PGNSP PGUID b f f 3831 3831 16 3886 3887 range_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 3886 (">=" PGNSP PGUID b f f 3831 3831 16 3885 3884 range_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 3887 (">" PGNSP PGUID b f f 3831 3831 16 3884 3885 range_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 3888 ("&&" PGNSP PGUID b f f 3831 3831 16 3888 0 range_overlaps areasel areajoinsel));
DESCR("overlaps");
DATA(insert OID = 3889 ("@>" PGNSP PGUID b f f 3831 2283 16 3891 0 range_contains_elem contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 3890 ("@>" PGNSP PGUID b f f 3831 3831 16 3892 0 range_contains contsel contjoinsel));
DESCR("contains");
DATA(insert OID = 3891 ("<@" PGNSP PGUID b f f 2283 3831 16 3889 0 elem_contained_by_range contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 3892 ("<@" PGNSP PGUID b f f 3831 3831 16 3890 0 range_contained_by contsel contjoinsel));
DESCR("is contained by");
DATA(insert OID = 3893 ("<<" PGNSP PGUID b f f 3831 3831 16 3894 0 range_before scalarltsel scalarltjoinsel));
DESCR("is left of");
DATA(insert OID = 3894 (">>" PGNSP PGUID b f f 3831 3831 16 3893 0 range_after scalargtsel scalargtjoinsel));
DESCR("is right of");
DATA(insert OID = 3895 ("&<" PGNSP PGUID b f f 3831 3831 16 0 0 range_overleft scalarltsel scalarltjoinsel));
DESCR("overlaps or is left of");
DATA(insert OID = 3896 ("&>" PGNSP PGUID b f f 3831 3831 16 0 0 range_overright scalargtsel scalargtjoinsel));
DESCR("overlaps or is right of");
DATA(insert OID = 3897 ("-|-" PGNSP PGUID b f f 3831 3831 16 3897 0 range_adjacent contsel contjoinsel));
DESCR("is adjacent to");
DATA(insert OID = 3898 ("+" PGNSP PGUID b f f 3831 3831 3831 3898 0 range_union - -));
DESCR("range union");
DATA(insert OID = 3899 ("-" PGNSP PGUID b f f 3831 3831 3831 0 0 range_minus - -));
DESCR("range difference");
DATA(insert OID = 3900 ("*" PGNSP PGUID b f f 3831 3831 3831 3900 0 range_intersect - -));
DESCR("range intersection");
DATA(insert OID = 3962 ( "->" PGNSP PGUID b f f 114 25 114 0 0 json_object_field - - ));
DESCR("get json object field");
DATA(insert OID = 3963 ( "->>" PGNSP PGUID b f f 114 25 25 0 0 json_object_field_text - - ));
DESCR("get json object field as text");
DATA(insert OID = 3964 ( "->" PGNSP PGUID b f f 114 23 114 0 0 json_array_element - - ));
DESCR("get json array element");
DATA(insert OID = 3965 ( "->>" PGNSP PGUID b f f 114 23 25 0 0 json_array_element_text - - ));
DESCR("get json array element as text");
DATA(insert OID = 3966 ( "#>" PGNSP PGUID b f f 114 1009 114 0 0 json_extract_path_op - - ));
DESCR("get value from json with path elements");
DATA(insert OID = 3967 ( "#>>" PGNSP PGUID b f f 114 1009 25 0 0 json_extract_path_text_op - - ));
DESCR("get value from json as text with path elements");
DATA(insert OID = 3211 ( "->" PGNSP PGUID b f f 3802 25 3802 0 0 jsonb_object_field - - ));
DESCR("get jsonb object field");
DATA(insert OID = 3477 ( "->>" PGNSP PGUID b f f 3802 25 25 0 0 jsonb_object_field_text - - ));
DESCR("get jsonb object field as text");
DATA(insert OID = 3212 ( "->" PGNSP PGUID b f f 3802 23 3802 0 0 jsonb_array_element - - ));
DESCR("get jsonb array element");
DATA(insert OID = 3481 ( "->>" PGNSP PGUID b f f 3802 23 25 0 0 jsonb_array_element_text - - ));
DESCR("get jsonb array element as text");
DATA(insert OID = 3213 ( "#>" PGNSP PGUID b f f 3802 1009 3802 0 0 jsonb_extract_path_op - - ));
DESCR("get value from jsonb with path elements");
DATA(insert OID = 3206 ( "#>>" PGNSP PGUID b f f 3802 1009 25 0 0 jsonb_extract_path_text_op - - ));
DESCR("get value from jsonb as text with path elements");
DATA(insert OID = 3240 ( "=" PGNSP PGUID b t t 3802 3802 16 3240 3241 jsonb_eq eqsel eqjoinsel ));
DESCR("equal");
DATA(insert OID = 3241 ( "<>" PGNSP PGUID b f f 3802 3802 16 3241 3240 jsonb_ne neqsel neqjoinsel ));
DESCR("not equal");
DATA(insert OID = 3242 ( "<" PGNSP PGUID b f f 3802 3802 16 3243 3245 jsonb_lt scalarltsel scalarltjoinsel ));
DESCR("less than");
DATA(insert OID = 3243 ( ">" PGNSP PGUID b f f 3802 3802 16 3242 3244 jsonb_gt scalargtsel scalargtjoinsel ));
DESCR("greater than");
DATA(insert OID = 3244 ( "<=" PGNSP PGUID b f f 3802 3802 16 3245 3243 jsonb_le scalarltsel scalarltjoinsel ));
DESCR("less than or equal to");
DATA(insert OID = 3245 ( ">=" PGNSP PGUID b f f 3802 3802 16 3244 3242 jsonb_ge scalargtsel scalargtjoinsel ));
DESCR("greater than or equal to");
/* No commutator? */
DATA(insert OID = 3246 ( "@>" PGNSP PGUID b f f 3802 3802 16 0 3250 jsonb_contains contsel contjoinsel ));
DESCR("contains");
DATA(insert OID = 3247 ( "?" PGNSP PGUID b f f 3802 25 16 0 0 jsonb_exists contsel contjoinsel ));
DESCR("exists");
DATA(insert OID = 3248 ( "?|" PGNSP PGUID b f f 3802 1009 16 0 0 jsonb_exists_any contsel contjoinsel ));
DESCR("exists any");
DATA(insert OID = 3249 ( "?&" PGNSP PGUID b f f 3802 1009 16 0 0 jsonb_exists_all contsel contjoinsel ));
DESCR("exists all");
DATA(insert OID = 3250 ( "<@" PGNSP PGUID b f f 3802 3802 16 0 3246 jsonb_contained contsel contjoinsel ));
DESCR("contained");
DATA(insert OID = 3251 ( "-" PGNSP PGUID b f f 3802 23 3802 0 0 5612 - - ));
DESCR("delete index");
DATA(insert OID = 3252 ( "-" PGNSP PGUID b f f 3802 25 3802 0 0 5613 - - ));
DESCR("delete text");
DATA(insert OID = 3253 ( "-" PGNSP PGUID b f f 3802 1009 3802 0 0 5614 - - ));
DESCR("delete text[]");
DATA(insert OID = 5550 ("=" PGNSP PGUID b t t 9003 9003 16 5550 5551 smalldatetime_eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 5551 ("<>" PGNSP PGUID b f f 9003 9003 16 5551 5550 smalldatetime_ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 5552 ("<" PGNSP PGUID b f f 9003 9003 16 5554 5549 smalldatetime_lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 5553 ("<=" PGNSP PGUID b f f 9003 9003 16 5549 5554 smalldatetime_le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 5554 (">" PGNSP PGUID b f f 9003 9003 16 5552 5553 smalldatetime_gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 5549 (">=" PGNSP PGUID b f f 9003 9003 16 5553 5552 smalldatetime_ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
/* hll */
DATA(insert OID = 4372 ( "=" PGNSP PGUID b f f 4301 4301 16 4372 4373 hll_eq eqsel eqjoinsel ));
DESCR("hyper log log equal op");
DATA(insert OID = 4373 ( "<>" PGNSP PGUID b f f 4301 4301 16 4373 4372 hll_ne neqsel neqjoinsel ));
DESCR("hyper log log not equal op");
DATA(insert OID = 4374 ( "||" PGNSP PGUID b f f 4301 4301 4301 0 0 hll_union - - ));
DESCR("hyper log log union op");
DATA(insert OID = 4375 ( "||" PGNSP PGUID b f f 4301 4303 4301 0 0 hll_add - - ));
DESCR("hyper log log add op");
DATA(insert OID = 4376 ( "||" PGNSP PGUID b f f 4303 4301 4301 0 0 hll_add_rev - - ));
DESCR("hyper log log add rev op");
DATA(insert OID = 4377 ( "#" PGNSP PGUID l f f 0 4301 701 0 0 hll_cardinality - - ));
DESCR("hyper log log cardinality op");
DATA(insert OID = 4378 ( "=" PGNSP PGUID b f f 4303 4303 16 4378 4379 hll_hashval_eq eqsel eqjoinsel ));
DESCR("hyper log log equal hashval op");
DATA(insert OID = 4379 ( "<>" PGNSP PGUID b f f 4303 4303 16 4379 4378 hll_hashval_ne neqsel neqjoinsel ));
DESCR("hyper log log not equal hashval op");
DATA(insert OID = 6000 ("=" PGNSP PGUID b f f 34 34 16 6000 6001 int16eq eqsel eqjoinsel));
DESCR("int16 equal");
DATA(insert OID = 6001 ("<>" PGNSP PGUID b f f 34 34 16 6001 6000 int16ne neqsel neqjoinsel));
DESCR("int16 not equal");
DATA(insert OID = 6002 ("<" PGNSP PGUID b f f 34 34 16 6004 6005 int16lt scalarltsel scalarltjoinsel));
DESCR("int16 less than");
DATA(insert OID = 6003 ("<=" PGNSP PGUID b f f 34 34 16 6005 6004 int16le scalarltsel scalarltjoinsel));
DESCR("int16 less or equal");
DATA(insert OID = 6004 (">" PGNSP PGUID b f f 34 34 16 6002 6003 int16gt scalargtsel scalargtjoinsel));
DESCR("int16 greater");
DATA(insert OID = 6005 (">=" PGNSP PGUID b f f 34 34 16 6003 6002 int16ge scalargtsel scalargtjoinsel));
DESCR("int16 greater or equal");
DATA(insert OID = 6006 ("+" PGNSP PGUID b f f 34 34 34 6006 0 int16pl - -));
DESCR("int16 plus");
DATA(insert OID = 6007 ("-" PGNSP PGUID b f f 34 34 34 0 0 int16mi - -));
DESCR("int16 minus");
DATA(insert OID = 6008 ("*" PGNSP PGUID b f f 34 34 34 6008 0 int16mul - -));
DESCR("int16 multiply");
DATA(insert OID = 6009 ("/" PGNSP PGUID b f f 34 34 701 0 0 int16div - -));
DESCR("int16 divide");
/* set operators */
DATA(insert OID = 6435 ("=" PGNSP PGUID b t t 3272 3272 16 6435 6436 seteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6436 ("<>" PGNSP PGUID b f f 3272 3272 16 6436 6435 setne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6437 ("<" PGNSP PGUID b f f 3272 3272 16 6438 6440 setlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6438 (">" PGNSP PGUID b f f 3272 3272 16 6437 6439 setgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6439 ("<=" PGNSP PGUID b f f 3272 3272 16 6440 6438 setle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6440 (">=" PGNSP PGUID b f f 3272 3272 16 6439 6437 setge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6441 ("=" PGNSP PGUID b t t 3272 20 16 6462 6442 setint8eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6442 ("<>" PGNSP PGUID b f f 3272 20 16 6463 6441 setint8ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6443 ("<" PGNSP PGUID b f f 3272 20 16 6465 6446 setint8lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6444 (">" PGNSP PGUID b f f 3272 20 16 6464 6445 setint8gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6445 ("<=" PGNSP PGUID b f f 3272 20 16 6467 6444 setint8le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6446 (">=" PGNSP PGUID b f f 3272 20 16 6466 6443 setint8ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6447 ("=" PGNSP PGUID b t t 3272 21 16 6468 6448 setint2eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6448 ("<>" PGNSP PGUID b f f 3272 21 16 6469 6447 setint2ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6449 ("<" PGNSP PGUID b f f 3272 21 16 6471 6452 setint2lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6450 (">" PGNSP PGUID b f f 3272 21 16 6470 6451 setint2gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6451 ("<=" PGNSP PGUID b f f 3272 21 16 6473 6450 setint2le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6452 (">=" PGNSP PGUID b f f 3272 21 16 6472 6449 setint2ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6453 ("=" PGNSP PGUID b t t 3272 23 16 6474 6454 setint4eq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6454 ("<>" PGNSP PGUID b f f 3272 23 16 6475 6453 setint4ne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6455 ("<" PGNSP PGUID b f f 3272 23 16 6477 6458 setint4lt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6456 (">" PGNSP PGUID b f f 3272 23 16 6476 6457 setint4gt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6457 ("<=" PGNSP PGUID b f f 3272 23 16 6479 6456 setint4le scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6458 (">=" PGNSP PGUID b f f 3272 23 16 6478 6455 setint4ge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6462 ("=" PGNSP PGUID b t t 20 3272 16 6441 6463 int8seteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6463 ("<>" PGNSP PGUID b f f 20 3272 16 6442 6462 int8setne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6464 ("<" PGNSP PGUID b f f 20 3272 16 6444 6467 int8setlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6465 (">" PGNSP PGUID b f f 20 3272 16 6443 6466 int8setgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6466 ("<=" PGNSP PGUID b f f 20 3272 16 6446 6465 int8setle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6467 (">=" PGNSP PGUID b f f 20 3272 16 6445 6464 int8setge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6468 ("=" PGNSP PGUID b t t 21 3272 16 6447 6469 int2seteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6469 ("<>" PGNSP PGUID b f f 21 3272 16 6448 6468 int2setne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6470 ("<" PGNSP PGUID b f f 21 3272 16 6450 6473 int2setlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6471 (">" PGNSP PGUID b f f 21 3272 16 6449 6472 int2setgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6472 ("<=" PGNSP PGUID b f f 21 3272 16 6452 6471 int2setle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6473 (">=" PGNSP PGUID b f f 21 3272 16 6451 6470 int2setge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6474 ("=" PGNSP PGUID b t t 23 3272 16 6453 6475 int4seteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6475 ("<>" PGNSP PGUID b f f 23 3272 16 6454 6474 int4setne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6476 ("<" PGNSP PGUID b f f 23 3272 16 6456 6479 int4setlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6477 (">" PGNSP PGUID b f f 23 3272 16 6455 6478 int4setgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6478 ("<=" PGNSP PGUID b f f 23 3272 16 6458 6477 int4setle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6479 (">=" PGNSP PGUID b f f 23 3272 16 6457 6476 int4setge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6553 ("=" PGNSP PGUID b f t 3272 25 16 6559 6554 settexteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6554 ("<>" PGNSP PGUID b f f 3272 25 16 6560 6553 settextne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6555 ("<" PGNSP PGUID b f f 3272 25 16 6562 6558 settextlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6556 (">" PGNSP PGUID b f f 3272 25 16 6561 6557 settextgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6557 ("<=" PGNSP PGUID b f f 3272 25 16 6564 6556 settextle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6558 (">=" PGNSP PGUID b f f 3272 25 16 6563 6555 settextge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6559 ("=" PGNSP PGUID b f t 25 3272 16 6553 6560 textseteq eqsel eqjoinsel));
DESCR("equal");
DATA(insert OID = 6560 ("<>" PGNSP PGUID b f f 25 3272 16 6554 6559 textsetne neqsel neqjoinsel));
DESCR("not equal");
DATA(insert OID = 6561 ("<" PGNSP PGUID b f f 25 3272 16 6556 6564 textsetlt scalarltsel scalarltjoinsel));
DESCR("less than");
DATA(insert OID = 6562 (">" PGNSP PGUID b f f 25 3272 16 6555 6563 textsetgt scalargtsel scalargtjoinsel));
DESCR("greater than");
DATA(insert OID = 6563 ("<=" PGNSP PGUID b f f 25 3272 16 6558 6562 textsetle scalarltsel scalarltjoinsel));
DESCR("less than or equal");
DATA(insert OID = 6564 (">=" PGNSP PGUID b f f 25 3272 16 6557 6561 textsetge scalargtsel scalargtjoinsel));
DESCR("greater than or equal");
DATA(insert OID = 6565 ("-" PGNSP PGUID l f f 0 16 16 0 0 boolum - -));
DESCR("negate");
DATA(insert OID = 8311 ("<->" PGNSP PGUID b f f 8305 8305 701 8311 0 8433 - -));
DESCR("l2_distance");
DATA(insert OID = 8312 ("<#>" PGNSP PGUID b f f 8305 8305 701 8312 0 vector_negative_inner_product - -));
DESCR("vector_negative_inner_product");
DATA(insert OID = 8313 ("<=>" PGNSP PGUID b f f 8305 8305 701 8313 0 8435 - -));
DESCR("cosine_distance");
DATA(insert OID = 8314 ("<+>" PGNSP PGUID b f f 8305 8305 701 8314 0 8436 - -));
DESCR("l1_distance");
DATA(insert OID = 8339 ("||" PGNSP PGUID b f f 8305 8305 8305 0 0 vector_concat - -));
DESCR("vector_concat");
DATA(insert OID = 8319 ("<->" PGNSP PGUID b f f 8307 8307 701 8319 0 8465 - -));
DESCR("sparsevec_l2_distance");
DATA(insert OID = 8320 ("<#>" PGNSP PGUID b f f 8307 8307 701 8320 0 sparsevec_negative_inner_product - -));
DESCR("sparsevec_negative_inner_product");
DATA(insert OID = 8321 ("<=>" PGNSP PGUID b f f 8307 8307 701 8321 0 8466 - -));
DESCR("sparsevec_cosine_distance");
DATA(insert OID = 8322 ("<+>" PGNSP PGUID b f f 8307 8307 701 8322 0 8467 - -));
DESCR("sparsevec_l1_distance");
DATA(insert OID = 8323 ("<~>" PGNSP PGUID b f f 1560 1560 701 8323 0 hamming_distance - -));
DESCR("hamming_distance");
DATA(insert OID = 8324 ("<%>" PGNSP PGUID b f f 1560 1560 701 8324 0 jaccard_distance - -));
DESCR("jaccard_distance");
DATA(insert OID = 8325 ("+" PGNSP PGUID b f f 8305 8305 8305 8325 0 vector_add 0 0));
DESCR("vector_add");
DATA(insert OID = 8326 ("-" PGNSP PGUID b f f 8305 8305 8305 8326 0 vector_sub 0 0));
DESCR("vector_sub");
DATA(insert OID = 8349 ("*" PGNSP PGUID b f f 8305 8305 8305 8349 0 8203 0 0));
DESCR("vector_mul");
DATA(insert OID = 8327 ("<" PGNSP PGUID b f f 8305 8305 16 8329 8330 vector_lt scalarltsel scalarltjoinsel));
DESCR("vector less than");
DATA(insert OID = 8328 ("<=" PGNSP PGUID b f f 8305 8305 16 8330 8329 vector_le scalarltsel scalarltjoinsel));
DESCR("vector less than or equal");
DATA(insert OID = 8329 (">" PGNSP PGUID b f f 8305 8305 16 8327 8328 vector_gt scalargtsel scalargtjoinsel));
DESCR("vector greater than");
DATA(insert OID = 8330 (">=" PGNSP PGUID b f f 8305 8305 16 8328 8327 vector_ge scalargtsel scalargtjoinsel));
DESCR("vector greater than or equal");
DATA(insert OID = 8331 ("=" PGNSP PGUID b f t 8305 8305 16 8331 8332 vector_eq eqsel eqjoinsel));
DESCR("vector equal");
DATA(insert OID = 8332 ("<>" PGNSP PGUID b f f 8305 8305 16 8332 8331 vector_ne neqsel neqjoinsel));
DESCR("vector unequal");
DATA(insert OID = 8333 ("<" PGNSP PGUID b f f 8307 8307 16 8335 8336 sparsevec_lt scalarltsel scalarltjoinsel));
DESCR("sparsevec less than");
DATA(insert OID = 8334 ("<=" PGNSP PGUID b f f 8307 8307 16 8336 8335 sparsevec_le scalarltsel scalarltjoinsel));
DESCR("sparsevec less than or equal");
DATA(insert OID = 8335 (">" PGNSP PGUID b f f 8307 8307 16 8333 8334 sparsevec_gt scalargtsel scalargtjoinsel));
DESCR("sparsevec greater than");
DATA(insert OID = 8336 (">=" PGNSP PGUID b f f 8307 8307 16 8334 8333 sparsevec_ge scalargtsel scalargtjoinsel));
DESCR("sparsevec greater than or equal");
DATA(insert OID = 8337 ("=" PGNSP PGUID b f t 8307 8307 16 8337 8338 sparsevec_eq eqsel eqjoinsel));
DESCR("sparsevec equal");
DATA(insert OID = 8338 ("<>" PGNSP PGUID b f f 8307 8307 16 8338 8337 sparsevec_ne neqsel neqjoinsel));
DESCR("sparsevec unequal");
DATA(insert OID = 6207 ("<&>" PGNSP PGUID b f f 1009 1009 701 6207 0 bm25_scores_textarr 0 0));
DESCR("bm25 text array similarity");
DATA(insert OID = 6208 ("<&>" PGNSP PGUID b f f 25 25 701 6208 0 bm25_scores_text 0 0));
DESCR("bm25 text similarity");
/*
* function prototypes
*/
