head 1.35; access; symbols release_4_2:1.35 aix_ok:1.30 Version_2_1:1.12 Version_2:1.1; locks; strict; comment @ * @; 1.35 date 94.02.02.00.22.27; author marc; state Exp; branches; next 1.34; 1.34 date 94.01.28.07.05.41; author aoki; state Exp; branches; next 1.33; 1.33 date 94.01.11.22.52.29; author jolly; state Exp; branches; next 1.32; 1.32 date 93.10.22.01.10.10; author marcel; state Exp; branches; next 1.31; 1.31 date 93.10.05.22.27.51; author marcel; state Exp; branches; next 1.30; 1.30 date 93.07.24.21.23.57; author aoki; state Exp; branches; next 1.29; 1.29 date 93.07.17.00.12.54; author mao; state Exp; branches; next 1.28; 1.28 date 93.07.16.18.59.27; author avi; state Exp; branches; next 1.27; 1.27 date 93.06.23.19.08.36; author sunita; state Exp; branches; next 1.26; 1.26 date 93.06.09.18.58.34; author avi; state Exp; branches; next 1.25; 1.25 date 93.05.16.17.57.07; author avi; state Exp; branches; next 1.24; 1.24 date 93.02.19.23.09.32; author aoki; state Exp; branches; next 1.23; 1.23 date 93.02.19.01.29.35; author aoki; state Exp; branches; next 1.22; 1.22 date 93.01.05.02.31.00; author aoki; state Exp; branches; next 1.21; 1.21 date 92.12.19.01.38.45; author aoki; state Exp; branches; next 1.20; 1.20 date 92.12.16.02.55.34; author aoki; state Exp; branches; next 1.19; 1.19 date 92.08.21.05.41.01; author mer; state Exp; branches; next 1.18; 1.18 date 92.08.16.03.38.36; author mer; state Exp; branches; next 1.17; 1.17 date 92.07.28.19.12.15; author mao; state Exp; branches; next 1.16; 1.16 date 92.05.05.01.17.23; author mer; state Exp; branches; next 1.15; 1.15 date 92.03.02.21.23.07; author mer; state Exp; branches; next 1.14; 1.14 date 91.11.05.06.11.55; author mao; state Exp; branches; next 1.13; 1.13 date 91.05.04.16.19.12; author mer; state Exp; branches; next 1.12; 1.12 date 91.03.03.19.35.24; author mao; state Exp; branches; next 1.11; 1.11 date 91.03.03.01.24.35; author mao; state Exp; branches; next 1.10; 1.10 date 91.03.03.00.36.29; author mao; state Exp; branches; next 1.9; 1.9 date 91.01.22.19.40.51; author mao; state Exp; branches; next 1.8; 1.8 date 90.10.15.23.25.41; author cimarron; state Exp; branches; next 1.7; 1.7 date 90.10.03.16.31.36; author hong; state Exp; branches; next 1.6; 1.6 date 90.10.03.16.21.43; author hong; state Exp; branches; next 1.5; 1.5 date 90.09.20.11.56.41; author hong; state Exp; branches; next 1.4; 1.4 date 90.08.17.08.51.38; author cimarron; state Exp; branches; next 1.3; 1.3 date 90.08.08.08.19.51; author cimarron; state Exp; branches; next 1.2; 1.2 date 90.08.01.13.37.59; author hong; state Exp; branches; next 1.1; 1.1 date 90.06.18.16.16.32; author cimarron; state Version_2; branches; next ; desc @@ 1.35 log @Fixes to make sure we don't expect NameData variables to be NULL terminated and that we don't write mroe than NAMEDATALEN chars into them @ text @/* ---------------------------------------------------------------- * FILE * pg_operator.h * * DESCRIPTION * definition of the system "operator" relation (pg_operator) * along with the relation's initial contents. * * NOTES * the genbki.sh 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... * * IDENTIFICATION * $Header: /usr/local/devel/postgres.test/src/backend/catalog/RCS/pg_operator.h,v 1.34 1994/01/28 07:05:41 aoki Exp marc $ * ---------------------------------------------------------------- */ #ifndef PgOperatorIncluded #define PgOperatorIncluded 1 /* include this only once */ /* ---------------- * postgres.h contains the system type definintions and the * CATALOG(), BOOTSTRAP and DATA() sugar words so this file * can be read by both genbki.sh and the C compiler. * ---------------- */ #include "tmp/postgres.h" /* ---------------- * pg_operator definition. cpp turns this into * typedef struct FormData_pg_operator * ---------------- */ CATALOG(pg_operator) { char16 oprname; oid oprowner; int2 oprprec; char oprkind; bool oprisleft; bool oprcanhash; oid oprleft; oid oprright; oid oprresult; oid oprcom; oid oprnegate; oid oprlsortop; oid oprrsortop; regproc oprcode; regproc oprrest; regproc oprjoin; } FormData_pg_operator; /* ---------------- * Form_pg_operator corresponds to a pointer to a tuple with * the format of pg_operator relation. * ---------------- */ typedef FormData_pg_operator *Form_pg_operator; /* ---------------- * compiler constants for pg_operator * ---------------- */ #define Name_pg_operator "pg_operator" #define Natts_pg_operator 16 #define Anum_pg_operator_oprname 1 #define Anum_pg_operator_oprowner 2 #define Anum_pg_operator_oprprec 3 #define Anum_pg_operator_oprkind 4 #define Anum_pg_operator_oprisleft 5 #define Anum_pg_operator_oprcanhash 6 #define Anum_pg_operator_oprleft 7 #define Anum_pg_operator_oprright 8 #define Anum_pg_operator_oprresult 9 #define Anum_pg_operator_oprcom 10 #define Anum_pg_operator_oprnegate 11 #define Anum_pg_operator_oprlsortop 12 #define Anum_pg_operator_oprrsortop 13 #define Anum_pg_operator_oprcode 14 #define Anum_pg_operator_oprrest 15 #define Anum_pg_operator_oprjoin 16 /* ---------------- * initial contents of pg_operator * ---------------- */ DATA(insert OID = 85 ( "!=" PGUID 0 b t f 16 16 16 85 91 0 0 boolne neqsel neqjoinsel )); DATA(insert OID = 91 ( "=" PGUID 0 b t t 16 16 16 91 85 0 0 booleq eqsel eqjoinsel )); #define BooleanEqualOperator 91 DATA(insert OID = 92 ( "=" PGUID 0 b t t 18 18 16 92 630 0 0 chareq eqsel eqjoinsel )); DATA(insert OID = 412 ( "=" PGUID 0 b t t 409 409 16 412 0 0 0 char2eq eqsel eqjoinsel )); DATA(insert OID = 413 ( "=" PGUID 0 b t t 410 410 16 413 0 0 0 char4eq eqsel eqjoinsel )); DATA(insert OID = 414 ( "=" PGUID 0 b t t 411 411 16 414 0 0 0 char8eq eqsel eqjoinsel )); DATA(insert OID = 93 ( "=" PGUID 0 b t t 19 19 16 93 0 0 0 char16eq eqsel eqjoinsel )); DATA(insert OID = 94 ( "=" PGUID 0 b t t 21 21 16 94 519 95 95 int2eq eqsel eqjoinsel )); DATA(insert OID = 95 ( "<" PGUID 0 b t f 21 21 16 520 524 0 0 int2lt intltsel intltjoinsel )); DATA(insert OID = 96 ( "=" PGUID 0 b t t 23 23 16 96 518 97 97 int4eq eqsel eqjoinsel )); DATA(insert OID = 97 ( "<" PGUID 0 b t f 23 23 16 521 525 0 0 int4lt intltsel intltjoinsel )); DATA(insert OID = 98 ( "=" PGUID 0 b t t 25 25 16 98 531 0 0 texteq eqsel eqjoinsel )); DATA(insert OID = 329 ( "=" PGUID 0 b t t 1000 1000 16 329 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 349 ( "=" PGUID 0 b t t 1001 1001 16 349 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 374 ( "=" PGUID 0 b t t 1002 1002 16 374 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 375 ( "=" PGUID 0 b t t 1003 1003 16 375 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 376 ( "=" PGUID 0 b t t 1004 1004 16 376 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 377 ( "=" PGUID 0 b t t 1005 1005 16 377 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 378 ( "=" PGUID 0 b t t 1006 1006 16 378 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 379 ( "=" PGUID 0 b t t 1007 1007 16 379 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 380 ( "=" PGUID 0 b t t 1008 1008 16 380 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 381 ( "=" PGUID 0 b t t 1009 1009 16 381 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 382 ( "=" PGUID 0 b t t 1028 1028 16 382 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 383 ( "=" PGUID 0 b t t 1010 1010 16 383 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 384 ( "=" PGUID 0 b t t 1011 1011 16 384 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 385 ( "=" PGUID 0 b t t 1012 1012 16 385 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 386 ( "=" PGUID 0 b t t 1013 1013 16 386 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 387 ( "=" PGUID 0 b t t 1014 1014 16 387 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 388 ( "=" PGUID 0 b t t 1015 1015 16 388 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 389 ( "=" PGUID 0 b t t 1016 1016 16 389 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 390 ( "=" PGUID 0 b t t 1017 1017 16 390 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 391 ( "=" PGUID 0 b t t 1018 1018 16 391 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 392 ( "=" PGUID 0 b t t 1019 1019 16 392 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 393 ( "=" PGUID 0 b t t 1020 1020 16 393 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 394 ( "=" PGUID 0 b t t 1021 1021 16 394 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 395 ( "=" PGUID 0 b t t 1022 1022 16 395 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 396 ( "=" PGUID 0 b t t 1023 1023 16 396 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 397 ( "=" PGUID 0 b t t 1024 1024 16 397 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 398 ( "=" PGUID 0 b t t 1025 1025 16 398 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 399 ( "=" PGUID 0 b t t 1026 1026 16 399 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 400 ( "=" PGUID 0 b t t 1027 1027 16 400 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 401 ( "=" PGUID 0 b t t 1034 1034 16 401 0 0 0 array_eq eqsel eqjoinsel )); DATA(insert OID = 485 ( "<<" PGUID 0 b t f 604 604 16 0 0 0 0 poly_left intltsel intltjoinsel )); DATA(insert OID = 486 ( "&<" PGUID 0 b t f 604 604 16 0 0 0 0 poly_overleft intltsel intltjoinsel )); DATA(insert OID = 487 ( "&>" PGUID 0 b t f 604 604 16 0 0 0 0 poly_overright intltsel intltjoinsel )); DATA(insert OID = 488 ( ">>" PGUID 0 b t f 604 604 16 0 0 0 0 poly_right intltsel intltjoinsel )); DATA(insert OID = 489 ( "@@" PGUID 0 b t f 604 604 16 0 0 0 0 poly_contained intltsel intltjoinsel )); DATA(insert OID = 490 ( "~" PGUID 0 b t f 604 604 16 0 0 0 0 poly_contain intltsel intltjoinsel )); DATA(insert OID = 491 ( "~=" PGUID 0 b t f 604 604 16 0 0 0 0 poly_same intltsel intltjoinsel )); DATA(insert OID = 492 ( "&&" PGUID 0 b t f 604 604 16 0 0 0 0 poly_overlap intltsel intltjoinsel )); DATA(insert OID = 493 ( "<<" PGUID 0 b t f 603 603 16 0 0 0 0 box_left intltsel intltjoinsel )); DATA(insert OID = 494 ( "&<" PGUID 0 b t f 603 603 16 0 0 0 0 box_overleft intltsel intltjoinsel )); DATA(insert OID = 495 ( "&>" PGUID 0 b t f 603 603 16 0 0 0 0 box_overright intltsel intltjoinsel )); DATA(insert OID = 496 ( ">>" PGUID 0 b t f 603 603 16 0 0 0 0 box_right intltsel intltjoinsel )); DATA(insert OID = 497 ( "@@" PGUID 0 b t f 603 603 16 0 0 0 0 box_contained intltsel intltjoinsel )); DATA(insert OID = 498 ( "~" PGUID 0 b t f 603 603 16 0 0 0 0 box_contain intltsel intltjoinsel )); DATA(insert OID = 499 ( "~=" PGUID 0 b t f 603 603 16 0 0 0 0 box_same intltsel intltjoinsel )); DATA(insert OID = 500 ( "&&" PGUID 0 b t f 603 603 16 0 0 0 0 box_overlap intltsel intltjoinsel )); DATA(insert OID = 501 ( ">=" PGUID 0 b t f 603 603 16 0 0 0 0 box_ge areasel areajoinsel )); DATA(insert OID = 502 ( ">" PGUID 0 b t f 603 603 16 0 0 0 0 box_gt areasel areajoinsel )); DATA(insert OID = 503 ( "=" PGUID 0 b t t 603 603 16 0 0 0 0 box_eq areasel areajoinsel )); DATA(insert OID = 504 ( "<" PGUID 0 b t f 603 603 16 0 0 0 0 box_lt areasel areajoinsel )); DATA(insert OID = 505 ( "<=" PGUID 0 b t f 603 603 16 0 0 0 0 box_le areasel areajoinsel )); DATA(insert OID = 506 ( "!^" PGUID 0 b t f 600 600 16 0 0 0 0 point_above intltsel intltjoinsel )); DATA(insert OID = 507 ( "!<" PGUID 0 b t f 600 600 16 0 0 0 0 point_left intltsel intltjoinsel )); DATA(insert OID = 508 ( "!>" PGUID 0 b t f 600 600 16 0 0 0 0 point_right intltsel intltjoinsel )); DATA(insert OID = 509 ( "!|" PGUID 0 b t f 600 600 16 0 0 0 0 point_below intltsel intltjoinsel )); DATA(insert OID = 510 ( "=|=" PGUID 0 b t f 600 600 16 0 0 0 0 point_eq intltsel intltjoinsel )); DATA(insert OID = 511 ( "--->" PGUID 0 b t f 600 603 16 0 0 0 0 on_pb intltsel intltjoinsel )); DATA(insert OID = 512 ( "---`" PGUID 0 b t f 600 602 16 0 0 0 0 on_ppath intltsel intltjoinsel )); DATA(insert OID = 513 ( "@@@@" PGUID 0 l t f 0 603 600 0 0 0 0 box_center intltsel intltjoinsel )); DATA(insert OID = 514 ( "*" PGUID 0 b t f 23 23 23 514 0 0 0 int4mul intltsel intltjoinsel )); DATA(insert OID = 515 ( "!" PGUID 0 r t f 23 0 23 0 0 0 0 int4fac intltsel intltjoinsel )); DATA(insert OID = 516 ( "!!" PGUID 0 l t f 0 23 23 0 0 0 0 int4fac intltsel intltjoinsel )); DATA(insert OID = 517 ( "<--->" PGUID 0 b t f 600 600 23 0 0 0 0 pointdist intltsel intltjoinsel )); DATA(insert OID = 518 ( "!=" PGUID 0 b t f 23 23 16 518 96 0 0 int4ne neqsel neqjoinsel )); DATA(insert OID = 519 ( "!=" PGUID 0 b t f 21 21 16 519 94 0 0 int2ne neqsel neqjoinsel )); DATA(insert OID = 520 ( ">" PGUID 0 b t f 21 21 16 95 0 0 0 int2gt intgtsel intgtjoinsel )); DATA(insert OID = 521 ( ">" PGUID 0 b t f 23 23 16 97 0 0 0 int4gt intgtsel intgtjoinsel )); DATA(insert OID = 522 ( "<=" PGUID 0 b t f 21 21 16 524 520 0 0 int2le intltsel intltjoinsel )); DATA(insert OID = 523 ( "<=" PGUID 0 b t f 23 23 16 525 521 0 0 int4le intltsel intltjoinsel )); DATA(insert OID = 524 ( ">=" PGUID 0 b t f 21 21 16 522 95 0 0 int2ge intgtsel intgtjoinsel )); DATA(insert OID = 525 ( ">=" PGUID 0 b t f 23 23 16 523 97 0 0 int4ge intgtsel intgtjoinsel )); DATA(insert OID = 526 ( "*" PGUID 0 b t f 21 21 21 526 0 0 0 int2mul intltsel intltjoinsel )); DATA(insert OID = 527 ( "/" PGUID 0 b t f 21 21 21 0 0 0 0 int2div intltsel intltjoinsel )); DATA(insert OID = 528 ( "/" PGUID 0 b t f 23 23 23 0 0 0 0 int4div intltsel intltjoinsel )); DATA(insert OID = 529 ( "%" PGUID 0 b t f 21 21 21 6 0 0 0 int2mod intltsel intltjoinsel )); DATA(insert OID = 530 ( "%" PGUID 0 b t f 23 23 23 6 0 0 0 int4mod intltsel intltjoinsel )); DATA(insert OID = 531 ( "!=" PGUID 0 b t f 25 25 16 531 98 0 0 textne neqsel neqjoinsel )); DATA(insert OID = 532 ( "=" PGUID 0 b t t 21 23 16 533 538 95 97 int24eq eqsel eqjoinsel )); DATA(insert OID = 533 ( "=" PGUID 0 b t t 23 21 16 532 539 97 95 int42eq eqsel eqjoinsel )); DATA(insert OID = 534 ( "<" PGUID 0 b t f 21 23 16 537 542 0 0 int24lt intltsel intltjoinsel )); DATA(insert OID = 535 ( "<" PGUID 0 b t f 23 21 16 536 543 0 0 int42lt intltsel intltjoinsel )); DATA(insert OID = 536 ( ">" PGUID 0 b t f 21 23 16 535 540 0 0 int24gt intgtsel intgtjoinsel )); DATA(insert OID = 537 ( ">" PGUID 0 b t f 23 21 16 534 541 0 0 int42gt intgtsel intgtjoinsel )); DATA(insert OID = 538 ( "!=" PGUID 0 b t f 21 23 16 539 532 0 0 int24ne neqsel neqjoinsel )); DATA(insert OID = 539 ( "!=" PGUID 0 b t f 23 21 16 538 533 0 0 int42ne neqsel neqjoinsel )); DATA(insert OID = 540 ( "<=" PGUID 0 b t f 21 23 16 543 536 0 0 int24le intltsel intltjoinsel )); DATA(insert OID = 541 ( "<=" PGUID 0 b t f 23 21 16 542 537 0 0 int42le intltsel intltjoinsel )); DATA(insert OID = 542 ( ">=" PGUID 0 b t f 21 23 16 541 534 0 0 int24ge intgtsel intgtjoinsel )); DATA(insert OID = 543 ( ">=" PGUID 0 b t f 23 21 16 540 535 0 0 int42ge intgtsel intgtjoinsel )); DATA(insert OID = 544 ( "*" PGUID 0 b t f 21 23 23 545 0 0 0 int24mul intltsel intltjoinsel )); DATA(insert OID = 545 ( "*" PGUID 0 b t f 23 21 23 544 0 0 0 int42mul intltsel intltjoinsel )); DATA(insert OID = 546 ( "/" PGUID 0 b t f 21 23 23 0 0 0 0 int24div intltsel intltjoinsel )); DATA(insert OID = 547 ( "/" PGUID 0 b t f 23 21 23 0 0 0 0 int42div intltsel intltjoinsel )); DATA(insert OID = 548 ( "%" PGUID 0 b t f 21 23 23 6 0 0 0 int24mod intltsel intltjoinsel )); DATA(insert OID = 549 ( "%" PGUID 0 b t f 23 21 23 6 0 0 0 int42mod intltsel intltjoinsel )); DATA(insert OID = 550 ( "+" PGUID 0 b t f 21 21 21 550 0 0 0 int2pl intltsel intltjoinsel )); DATA(insert OID = 551 ( "+" PGUID 0 b t f 23 23 23 551 0 0 0 int4pl intltsel intltjoinsel )); DATA(insert OID = 552 ( "+" PGUID 0 b t f 21 23 23 553 0 0 0 int24pl intltsel intltjoinsel )); DATA(insert OID = 553 ( "+" PGUID 0 b t f 23 21 23 552 0 0 0 int42pl intltsel intltjoinsel )); DATA(insert OID = 554 ( "-" PGUID 0 b t f 21 21 21 0 0 0 0 int2mi intltsel intltjoinsel )); DATA(insert OID = 555 ( "-" PGUID 0 b t f 23 23 23 0 0 0 0 int4mi intltsel intltjoinsel )); DATA(insert OID = 556 ( "-" PGUID 0 b t f 21 23 23 0 0 0 0 int24mi intltsel intltjoinsel )); DATA(insert OID = 557 ( "-" PGUID 0 b t f 23 21 23 0 0 0 0 int42mi intltsel intltjoinsel )); DATA(insert OID = 0 ( "-" PGUID 0 l t f 0 23 23 0 0 0 0 int4um intltsel intltjoinsel )); DATA(insert OID = 0 ( "-" PGUID 0 l t f 0 21 21 0 0 0 0 int2um intltsel intltjoinsel )); DATA(insert OID = 560 ( "=" PGUID 0 b t t 702 702 16 560 561 562 562 abstimeeq eqsel eqjoinsel )); DATA(insert OID = 561 ( "!=" PGUID 0 b t f 702 702 16 561 560 0 0 abstimene neqsel neqjoinsel )); DATA(insert OID = 562 ( "<" PGUID 0 b t f 702 702 16 563 565 0 0 abstimelt intltsel intltjoinsel )); DATA(insert OID = 563 ( ">" PGUID 0 b t f 702 702 16 562 564 0 0 abstimegt intltsel intltjoinsel )); DATA(insert OID = 564 ( "<=" PGUID 0 b t f 702 702 16 565 563 0 0 abstimele intltsel intltjoinsel )); DATA(insert OID = 565 ( ">=" PGUID 0 b t f 702 702 16 564 562 0 0 abstimege intltsel intltjoinsel )); DATA(insert OID = 566 ( "=" PGUID 0 b t t 703 703 16 566 567 568 568 reltimeeq - - )); DATA(insert OID = 567 ( "!=" PGUID 0 b t f 703 703 16 567 566 0 0 reltimene - - )); DATA(insert OID = 568 ( "<" PGUID 0 b t f 703 703 16 569 571 0 0 reltimelt - - )); DATA(insert OID = 569 ( ">" PGUID 0 b t f 703 703 16 568 570 0 0 reltimegt - - )); DATA(insert OID = 570 ( "<=" PGUID 0 b t f 703 703 16 571 569 0 0 reltimele - - )); DATA(insert OID = 571 ( ">=" PGUID 0 b t f 703 703 16 570 568 0 0 reltimege - - )); DATA(insert OID = 572 ( "=" PGUID 0 b t t 704 704 16 572 0 0 0 intervaleq - - )); DATA(insert OID = 573 ( "<<" PGUID 0 b t f 704 704 16 0 0 0 0 intervalct - - )); DATA(insert OID = 574 ( "&&" PGUID 0 b t f 704 704 16 0 0 0 0 intervalov - - )); DATA(insert OID = 575 ( "#=" PGUID 0 b t f 704 703 16 0 576 0 568 intervalleneq - - )); DATA(insert OID = 576 ( "#!=" PGUID 0 b t f 704 703 16 0 575 0 568 intervallenne - - )); DATA(insert OID = 577 ( "#<" PGUID 0 b t f 704 703 16 0 580 0 568 intervallenlt - - )); DATA(insert OID = 578 ( "#>" PGUID 0 b t f 704 703 16 0 579 0 568 intervallengt - - )); DATA(insert OID = 579 ( "#<=" PGUID 0 b t f 704 703 16 0 578 0 568 intervallenle - - )); DATA(insert OID = 580 ( "#>=" PGUID 0 b t f 704 703 16 0 577 0 568 intervallenge - - )); DATA(insert OID = 581 ( "+" PGUID 0 b t f 702 703 702 581 0 0 0 timepl - - )); DATA(insert OID = 582 ( "-" PGUID 0 b t f 702 703 702 0 0 0 0 timemi - - )); DATA(insert OID = 583 ( "" PGUID 0 b t f 702 704 16 0 0 562 0 ininterval - - )); DATA(insert OID = 584 ( "-" PGUID 0 l t f 0 700 700 0 0 0 0 float4um - - )); DATA(insert OID = 585 ( "-" PGUID 0 l t f 0 701 701 0 0 0 0 float8um - - )); DATA(insert OID = 586 ( "+" PGUID 0 b t f 700 700 700 586 0 0 0 float4pl - - )); DATA(insert OID = 587 ( "-" PGUID 0 b t f 700 700 700 0 0 0 0 float4mi - - )); DATA(insert OID = 588 ( "/" PGUID 0 b t f 700 700 700 0 0 0 0 float4div - - )); DATA(insert OID = 589 ( "*" PGUID 0 b t f 700 700 700 589 0 0 0 float4mul - - )); DATA(insert OID = 590 ( "@@" PGUID 0 l t f 0 700 700 0 0 0 0 float4abs - - )); DATA(insert OID = 591 ( "+" PGUID 0 b t f 701 701 701 591 0 0 0 float8pl - - )); DATA(insert OID = 592 ( "-" PGUID 0 b t f 701 701 701 0 0 0 0 float8mi - - )); DATA(insert OID = 593 ( "/" PGUID 0 b t f 701 701 701 0 0 0 0 float8div - - )); DATA(insert OID = 594 ( "*" PGUID 0 b t f 701 701 701 594 0 0 0 float8mul - - )); DATA(insert OID = 595 ( "@@" PGUID 0 l t f 0 701 701 0 0 0 0 float8abs - - )); DATA(insert OID = 596 ( "|/" PGUID 0 l t f 0 701 701 0 0 0 0 dsqrt - - )); DATA(insert OID = 597 ( "||/" PGUID 0 l t f 0 701 701 0 0 0 0 dcbrt - - )); DATA(insert OID = 598 ( "%" PGUID 0 l t f 0 701 701 0 0 0 0 dtrunc - - )); DATA(insert OID = 599 ( "%" PGUID 0 r t f 701 0 701 0 0 0 0 dround - - )); DATA(insert OID = 965 ( "^" PGUID 0 b t f 701 701 701 0 0 0 0 dpow - - )); DATA(insert OID = 601 ( ":" PGUID 0 l t f 0 701 701 0 0 0 0 dexp - - )); DATA(insert OID = 602 ( ";" PGUID 0 l t f 0 701 701 0 0 0 0 dlog1 - - )); DATA(insert OID = 603 ( "|" PGUID 0 l t f 0 704 702 0 0 0 0 intervalstart - - )); DATA(insert OID = 606 ( "<>" PGUID 0 b t f 702 702 704 0 0 0 0 mktinterval - - )); DATA(insert OID = 607 ( "=" PGUID 0 b t t 26 26 16 607 608 97 97 oideq eqsel eqjoinsel )); #define OIDEqualOperator 607 /* XXX planner/prep/semanopt.c crock */ DATA(insert OID = 608 ( "!=" PGUID 0 b t f 26 26 16 608 607 0 0 oidne neqsel neqjoinsel )); DATA(insert OID = 609 ( "<" PGUID 0 b t f 26 26 16 610 612 0 0 int4lt intltsel intltjoinsel )); DATA(insert OID = 610 ( ">" PGUID 0 b t f 26 26 16 609 611 0 0 int4gt intgtsel intgtjoinsel )); DATA(insert OID = 611 ( "<=" PGUID 0 b t f 26 26 16 612 610 0 0 int4le intltsel intltjoinsel )); DATA(insert OID = 612 ( ">=" PGUID 0 b t f 26 26 16 611 609 0 0 int4ge intgtsel intgtjoinsel )); DATA(insert OID = 620 ( "=" PGUID 0 b t t 700 700 16 620 621 622 622 float4eq eqsel eqjoinsel )); DATA(insert OID = 621 ( "!=" PGUID 0 b t f 700 700 16 621 620 0 0 float4ne neqsel neqjoinsel )); DATA(insert OID = 622 ( "<" PGUID 0 b t f 700 700 16 623 625 0 0 float4lt intltsel intltjoinsel )); DATA(insert OID = 623 ( ">" PGUID 0 b t f 700 700 16 622 624 0 0 float4gt intgtsel intgtjoinsel )); DATA(insert OID = 624 ( "<=" PGUID 0 b t f 700 700 16 625 623 0 0 float4le intltsel intltjoinsel )); DATA(insert OID = 625 ( ">=" PGUID 0 b t f 700 700 16 624 622 0 0 float4ge intgtsel intgtjoinsel )); DATA(insert OID = 626 ( "!!=" PGUID 0 b t f 23 19 16 0 0 0 0 int4notin "-" "-")); DATA(insert OID = 627 ( "!!=" PGUID 0 b t f 26 19 16 0 0 0 0 oidnotin "-" "-")); #define OIDNotInOperator 627 /* XXX planner/prep/semanopt.c crock */ DATA(insert OID = 630 ( "!=" PGUID 0 b t f 18 18 16 630 92 0 0 charne neqsel neqjoinsel )); DATA(insert OID = 631 ( "<" PGUID 0 b t f 18 18 16 633 634 0 0 charlt intltsel intltjoinsel )); DATA(insert OID = 632 ( "<=" PGUID 0 b t f 18 18 16 634 633 0 0 charle intltsel intltjoinsel )); DATA(insert OID = 633 ( ">" PGUID 0 b t f 18 18 16 631 632 0 0 chargt intltsel intltjoinsel )); DATA(insert OID = 634 ( ">=" PGUID 0 b t f 18 18 16 632 631 0 0 charge intltsel intltjoinsel )); DATA(insert OID = 635 ( "+" PGUID 0 b t f 18 18 18 0 0 0 0 charpl eqsel eqjoinsel )); DATA(insert OID = 636 ( "-" PGUID 0 b t f 18 18 18 0 0 0 0 charmi eqsel eqjoinsel )); DATA(insert OID = 637 ( "*" PGUID 0 b t f 18 18 18 0 0 0 0 charmul eqsel eqjoinsel )); DATA(insert OID = 638 ( "/" PGUID 0 b t f 18 18 18 0 0 0 0 chardiv eqsel eqjoinsel )); DATA(insert OID = 839 ( "~" PGUID 0 b t f 409 25 16 0 841 0 0 char2regexeq eqsel eqjoinsel )); DATA(insert OID = 841 ( "!~" PGUID 0 b t f 409 25 16 0 839 0 0 char2regexne neqsel neqjoinsel )); DATA(insert OID = 840 ( "~" PGUID 0 b t f 410 25 16 0 842 0 0 char4regexeq eqsel eqjoinsel )); DATA(insert OID = 842 ( "!~" PGUID 0 b t f 410 25 16 0 840 0 0 char4regexne neqsel neqjoinsel )); DATA(insert OID = 697 ( "~" PGUID 0 b t f 411 25 16 0 698 0 0 char8regexeq eqsel eqjoinsel )); DATA(insert OID = 698 ( "!~" PGUID 0 b t f 411 25 16 0 697 0 0 char8regexne neqsel neqjoinsel )); DATA(insert OID = 639 ( "~" PGUID 0 b t f 19 25 16 0 640 0 0 char16regexeq eqsel eqjoinsel )); DATA(insert OID = 640 ( "!~" PGUID 0 b t f 19 25 16 0 639 0 0 char16regexne neqsel neqjoinsel )); DATA(insert OID = 641 ( "~" PGUID 0 b t f 25 25 16 0 642 0 0 textregexeq eqsel eqjoinsel )); DATA(insert OID = 642 ( "!~" PGUID 0 b t f 25 25 16 0 641 0 0 textregexne eqsel eqjoinsel )); DATA(insert OID = 415 ( "!=" PGUID 0 b t f 409 409 16 412 415 0 0 char2ne neqsel neqjoinsel )); DATA(insert OID = 416 ( "!=" PGUID 0 b t f 410 410 16 413 416 0 0 char4ne neqsel neqjoinsel )); DATA(insert OID = 417 ( "!=" PGUID 0 b t f 411 411 16 414 417 0 0 char8ne neqsel neqjoinsel )); DATA(insert OID = 643 ( "!=" PGUID 0 b t f 19 19 16 93 643 0 0 char16ne neqsel neqjoinsel )); DATA(insert OID = 418 ( "<" PGUID 0 b t f 409 409 16 460 463 0 0 char2lt intltsel intltjoinsel )); DATA(insert OID = 419 ( "<" PGUID 0 b t f 410 410 16 461 464 0 0 char4lt intltsel intltjoinsel )); DATA(insert OID = 420 ( "<" PGUID 0 b t f 411 411 16 462 465 0 0 char8lt intltsel intltjoinsel )); DATA(insert OID = 660 ( "<" PGUID 0 b t f 19 19 16 662 663 0 0 char16lt intltsel intltjoinsel )); DATA(insert OID = 457 ( "<=" PGUID 0 b t f 409 409 16 463 460 0 0 char2le intltsel intltjoinsel )); DATA(insert OID = 458 ( "<=" PGUID 0 b t f 410 410 16 464 461 0 0 char4le intltsel intltjoinsel )); DATA(insert OID = 459 ( "<=" PGUID 0 b t f 411 411 16 465 462 0 0 char8le intltsel intltjoinsel )); DATA(insert OID = 661 ( "<=" PGUID 0 b t f 19 19 16 663 662 0 0 char16le intltsel intltjoinsel )); DATA(insert OID = 460 ( ">" PGUID 0 b t f 409 409 16 418 457 0 0 char2gt intltsel intltjoinsel )); DATA(insert OID = 461 ( ">" PGUID 0 b t f 410 410 16 419 458 0 0 char4gt intltsel intltjoinsel )); DATA(insert OID = 462 ( ">" PGUID 0 b t f 411 411 16 420 459 0 0 char8gt intltsel intltjoinsel )); DATA(insert OID = 662 ( ">" PGUID 0 b t f 19 19 16 660 661 0 0 char16gt intltsel intltjoinsel )); DATA(insert OID = 463 ( ">=" PGUID 0 b t f 409 409 16 457 418 0 0 char2ge intltsel intltjoinsel )); DATA(insert OID = 464 ( ">=" PGUID 0 b t f 410 410 16 458 418 0 0 char4ge intltsel intltjoinsel )); DATA(insert OID = 465 ( ">=" PGUID 0 b t f 411 411 16 459 420 0 0 char8ge intltsel intltjoinsel )); DATA(insert OID = 663 ( ">=" PGUID 0 b t f 19 19 16 661 660 0 0 char16ge intltsel intltjoinsel )); DATA(insert OID = 664 ( "<" PGUID 0 b t f 25 25 16 666 667 0 0 text_lt intltsel intltjoinsel )); DATA(insert OID = 665 ( "<=" PGUID 0 b t f 25 25 16 667 666 0 0 text_le intltsel intltjoinsel )); DATA(insert OID = 666 ( ">" PGUID 0 b t f 25 25 16 664 665 0 0 text_gt intltsel intltjoinsel )); DATA(insert OID = 667 ( ">=" PGUID 0 b t f 25 25 16 665 664 0 0 text_ge intltsel intltjoinsel )); DATA(insert OID = 670 ( "=" PGUID 0 b t f 701 701 16 670 671 0 0 float8eq eqsel eqjoinsel )); DATA(insert OID = 671 ( "!=" PGUID 0 b t f 701 701 16 671 670 0 0 float8ne neqsel neqjoinsel )); DATA(insert OID = 672 ( "<" PGUID 0 b t f 701 701 16 674 675 0 0 float8lt intltsel intltjoinsel )); DATA(insert OID = 673 ( "<=" PGUID 0 b t f 701 701 16 675 674 0 0 float8le intltsel intltjoinsel )); DATA(insert OID = 674 ( ">" PGUID 0 b t f 701 701 16 672 673 0 0 float8gt intltsel intltjoinsel )); DATA(insert OID = 675 ( ">=" PGUID 0 b t f 701 701 16 673 672 0 0 float8ge intltsel intltjoinsel )); DATA(insert OID = 676 ( "<" PGUID 0 b t f 911 911 16 680 679 0 0 oidchar16lt intltsel intltjoinsel )); DATA(insert OID = 677 ( "<=" PGUID 0 b t f 911 911 16 679 680 0 0 oidchar16le intltsel intltjoinsel )); DATA(insert OID = 678 ( "=" PGUID 0 b t f 911 911 16 678 681 0 0 oidchar16eq intltsel intltjoinsel )); DATA(insert OID = 679 ( ">=" PGUID 0 b t f 911 911 16 677 676 0 0 oidchar16ge intltsel intltjoinsel )); DATA(insert OID = 680 ( ">" PGUID 0 b t f 911 911 16 676 677 0 0 oidchar16gt intltsel intltjoinsel )); DATA(insert OID = 681 ( "!=" PGUID 0 b t f 911 911 16 681 678 0 0 oidchar16ne intltsel intltjoinsel )); DATA(insert OID = 830 ( "<" PGUID 0 b t f 810 810 16 834 833 0 0 oidint2lt intltsel intltjoinsel )); DATA(insert OID = 831 ( "<=" PGUID 0 b t f 810 810 16 833 834 0 0 oidint2le intltsel intltjoinsel )); DATA(insert OID = 832 ( "=" PGUID 0 b t f 810 810 16 832 835 0 0 oidint2eq intltsel intltjoinsel )); DATA(insert OID = 833 ( ">=" PGUID 0 b t f 810 810 16 831 830 0 0 oidint2ge intltsel intltjoinsel )); DATA(insert OID = 834 ( ">" PGUID 0 b t f 810 810 16 830 831 0 0 oidint2gt intltsel intltjoinsel )); DATA(insert OID = 835 ( "!=" PGUID 0 b t f 810 810 16 835 832 0 0 oidint2ne intltsel intltjoinsel )); DATA(insert OID = 930 ( "<" PGUID 0 b t f 910 910 16 934 933 0 0 oidint4lt intltsel intltjoinsel )); DATA(insert OID = 931 ( "<=" PGUID 0 b t f 910 910 16 933 934 0 0 oidint4le intltsel intltjoinsel )); DATA(insert OID = 932 ( "=" PGUID 0 b t f 910 910 16 932 935 0 0 oidint4eq intltsel intltjoinsel )); DATA(insert OID = 933 ( ">=" PGUID 0 b t f 910 910 16 931 930 0 0 oidint4ge intltsel intltjoinsel )); DATA(insert OID = 934 ( ">" PGUID 0 b t f 910 910 16 930 931 0 0 oidint4gt intltsel intltjoinsel )); DATA(insert OID = 935 ( "!=" PGUID 0 b t f 910 910 16 935 932 0 0 oidint4ne intltsel intltjoinsel )); DATA(insert OID = 0 ( "+" PGUID 0 b t f 1034 1033 1034 0 0 0 0 aclinsert intltsel intltjoinsel )); DATA(insert OID = 0 ( "-" PGUID 0 b t f 1034 1033 1034 0 0 0 0 aclremove intltsel intltjoinsel )); DATA(insert OID = 0 ( "~" PGUID 0 b t f 1034 1033 16 0 0 0 0 aclcontains intltsel intltjoinsel )); /* ---------------- * old definition of OperatorTupleForm * ---------------- */ #ifndef OperatorTupleForm_Defined #define OperatorTupleForm_Defined 1 typedef struct OperatorTupleFormD { NameData oprname; ObjectId oprowner; uint16 oprprec; char oprkind; Boolean oprisleft; Boolean oprcanhash; ObjectId oprleft; ObjectId oprright; ObjectId oprresult; ObjectId oprcom; ObjectId oprnegate; ObjectId oprlsortop; ObjectId oprrsortop; RegProcedure oprcode; RegProcedure oprrest; RegProcedure oprjoin; } OperatorTupleFormD; typedef OperatorTupleFormD *OperatorTupleForm; #endif OperatorTupleForm_Defined /* ---------------- * old definition of struct operator * ---------------- */ #ifndef struct_operator_Defined #define struct_operator_Defined 1 struct operator { NameData oprname; OID oprowner; uint16 oprprec; char oprkind; Boolean oprisleft; Boolean oprcanhash; OID oprleft; OID oprright; OID oprresult; OID oprcom; OID oprnegate; OID oprlsortop; OID oprrsortop; REGPROC oprcode; REGPROC oprrest; REGPROC oprjoin; }; #endif struct_operator_Defined /* ---------------- * old style compiler constants. these are obsolete and * should not be used -cim 6/17/90 * ---------------- */ #define OperatorNameAttributeNumber \ Anum_pg_operator_oprname #define OperatorKindAttributeNumber \ Anum_pg_operator_oprkind #define OperatorLeftAttributeNumber \ Anum_pg_operator_oprleft #define OperatorRightAttributeNumber \ Anum_pg_operator_oprright #define OperatorResultAttributeNumber \ Anum_pg_operator_oprresult /* I'm not certain the next is correct -cim 6/17/90 */ #define OperatorProcedureAttributeNumber \ Anum_pg_operator_oprcode #define OperatorRestrictAttributeNumber \ Anum_pg_operator_oprrest #define OperatorJoinAttributeNumber \ Anum_pg_operator_oprjoin #define OperatorRelationNumberOfAttributes \ Natts_pg_operator #endif PgOperatorIncluded @ 1.34 log @you can't hashjoin != ... @ text @d17 1 a17 1 * $Header: /import/faerie/faerie/aoki/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.33 1994/01/11 22:52:29 jolly Exp aoki $ d388 1 a388 1 char oprname[16]; @ 1.33 log @changed entries for charmul, charpl, charmi, chardiv to return char instead of bool @ text @d17 1 a17 1 * $Header: /private/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.32 1993/10/22 01:10:10 marcel Exp jolly $ d90 1 a90 1 DATA(insert OID = 85 ( "!=" PGUID 0 b t t 16 16 16 85 91 0 0 boolne neqsel neqjoinsel )); @ 1.32 log @replaced duplicate oid @ text @d17 1 a17 1 * $Header: /usr/local/devel/marcel/src/backend/catalog/RCS/pg_operator.h,v 1.31 1993/10/05 22:27:51 marcel Exp marcel $ d277 4 a280 4 DATA(insert OID = 635 ( "+" PGUID 0 b t f 18 18 16 0 0 0 0 charpl eqsel eqjoinsel )); DATA(insert OID = 636 ( "-" PGUID 0 b t f 18 18 16 0 0 0 0 charmi eqsel eqjoinsel )); DATA(insert OID = 637 ( "*" PGUID 0 b t f 18 18 16 0 0 0 0 charmul eqsel eqjoinsel )); DATA(insert OID = 638 ( "/" PGUID 0 b t f 18 18 16 0 0 0 0 chardiv eqsel eqjoinsel )); @ 1.31 log @added operators for char2, char4, char8 (=, !=, ~, !~, <, <=, >, >=) @ text @d17 1 a17 1 * $Header: /home2/aoki/ultrix4/src/backend/catalog/RCS/pg_operator.h,v 1.30 1993/07/24 21:23:57 aoki Exp $ d249 1 a249 1 DATA(insert OID = 600 ( "^" PGUID 0 b t f 701 701 701 0 0 0 0 dpow - - )); d302 2 a303 2 DATA(insert OID = 458 ( "<=" PGUID 0 b t f 410 410 16 464 461 0 0 char2le intltsel intltjoinsel )); DATA(insert OID = 459 ( "<=" PGUID 0 b t f 411 411 16 465 462 0 0 char2le intltsel intltjoinsel )); @ 1.30 log @semanopt.c hardwired the ops that mao removed.. broke versions @ text @d17 1 a17 1 * $Header: /data/26/private/ultrix4/aoki/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.29 1993/07/17 00:12:54 mao Exp aoki $ d95 3 d282 8 a289 2 DATA(insert OID = 639 ( "~" PGUID 0 b t f 19 19 16 0 640 0 0 char16regexeq eqsel eqjoinsel )); DATA(insert OID = 640 ( "!~" PGUID 0 b t f 19 19 16 0 639 0 0 char16regexne neqsel neqjoinsel )); d292 3 d297 3 d301 3 d305 3 d309 3 @ 1.29 log @oddly enough, this fixes a bad bug in the planner. we had duplicate operators for oid comparisons in pg_operator. the parser always chose a different one from the one stored in pg_amop, so scans for oid equality would never use indices defined on oids. getting rid of one of the duplicates solves the problem. @ text @d17 1 a17 1 * $Header: /private/src/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.28 1993/07/16 18:59:27 avi Exp mao $ d251 3 a253 2 DATA(insert OID = 607 ( "=" PGUID 0 b t t 26 26 16 607 608 97 97 oideq eqsel eqjoinsel )); DATA(insert OID = 608 ( "!=" PGUID 0 b t f 26 26 16 608 607 0 0 oidne eqsel eqjoinsel )); d259 1 a259 1 DATA(insert OID = 621 ( "!=" PGUID 0 b t f 700 700 16 621 620 0 0 float4ne eqsel eqjoinsel )); d266 2 a267 1 DATA(insert OID = 630 ( "!=" PGUID 0 b t f 18 18 16 630 92 0 0 charne eqsel eqjoinsel )); d280 1 a280 1 DATA(insert OID = 640 ( "!~" PGUID 0 b t f 19 19 16 0 639 0 0 char16regexne eqsel eqjoinsel )); d283 1 a283 1 DATA(insert OID = 643 ( "!=" PGUID 0 b t f 19 19 16 93 643 0 0 char16ne eqsel eqjoinsel )); d295 1 a295 1 DATA(insert OID = 671 ( "!=" PGUID 0 b t f 701 701 16 671 670 0 0 float8ne eqsel eqjoinsel )); @ 1.28 log @added mktinterval operator "<>" @ text @d17 1 a17 1 * $Header: /private/src/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.27 1993/06/23 19:08:36 sunita Exp avi $ a205 2 DATA(insert OID = 558 ( "=" PGUID 0 b t t 26 26 16 558 559 0 0 oideq intltsel intltjoinsel )); DATA(insert OID = 559 ( "!=" PGUID 0 b t f 26 26 16 559 558 0 0 oidne neqsel neqjoinsel )); @ 1.27 log @added entries for "=" on arrays of base types. @ text @d17 1 a17 1 * $Header: /data/01/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.26 1993/06/09 18:58:34 avi Exp $ d252 1 @ 1.26 log @corrected typo in int42 > declaration @ text @d17 1 a17 1 * $Header: /private/src/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.25 1993/05/16 17:57:07 avi Exp avi $ d101 30 @ 1.25 log @oidint2 operations added @ text @d17 1 a17 1 * $Header: /private/src/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.24 1993/02/19 23:09:32 aoki Exp avi $ d153 1 a153 1 DATA(insert OID = 537 ( ">" PGUID 0 b t f 23 21 16 534 541 0 0 int42lt intgtsel intgtjoinsel )); @ 1.24 log @added acl ops @ text @d17 1 a17 1 * $Header: /home2/aoki/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.23 1993/02/19 01:29:35 aoki Exp aoki $ d276 7 @ 1.23 log @changed oidchar16 arg types to oidchar16 (from oidint4) @ text @d17 1 a17 1 * $Header: /home2/aoki/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.22 1993/01/05 02:31:00 aoki Exp aoki $ d283 4 @ 1.22 log @fixed function names to match reality @ text @d17 1 a17 1 * $Header: /home2/aoki/postgres/src/backend/catalog/RCS/pg_operator.h,v 1.21 1992/12/19 01:38:45 aoki Exp aoki $ d270 6 a275 6 DATA(insert OID = 676 ( "<" PGUID 0 b t f 910 910 16 680 679 0 0 oidchar16lt intltsel intltjoinsel )); DATA(insert OID = 677 ( "<=" PGUID 0 b t f 910 910 16 679 680 0 0 oidchar16le intltsel intltjoinsel )); DATA(insert OID = 678 ( "=" PGUID 0 b t f 910 910 16 678 681 0 0 oidchar16eq intltsel intltjoinsel )); DATA(insert OID = 679 ( ">=" PGUID 0 b t f 910 910 16 677 676 0 0 oidchar16ge intltsel intltjoinsel )); DATA(insert OID = 680 ( ">" PGUID 0 b t f 910 910 16 676 677 0 0 oidchar16gt intltsel intltjoinsel )); DATA(insert OID = 681 ( "!=" PGUID 0 b t f 910 910 16 681 678 0 0 oidchar16ne intltsel intltjoinsel )); @ 1.21 log @second checkin for acls and other stuff @ text @d13 3 d17 1 a17 1 * $Header: /usr/local/dev/postgres/mastertree/newconf/RCS/pg_operator.h,v 1.19 1992/08/21 05:41:01 mer Exp $ d177 1 a177 1 DATA(insert OID = 559 ( "!=" PGUID 0 b t f 26 26 16 559 558 0 0 oidneq neqsel neqjoinsel )); d223 1 a223 1 DATA(insert OID = 608 ( "!=" PGUID 0 b t f 26 26 16 608 607 0 0 oidneq eqsel eqjoinsel )); d238 4 a241 4 DATA(insert OID = 631 ( "<" PGUID 0 b t f 18 18 16 633 634 0 0 charlt intltsel intltjoingsel )); DATA(insert OID = 632 ( "<=" PGUID 0 b t f 18 18 16 634 633 0 0 charle intltsel intltjoingsel )); DATA(insert OID = 633 ( ">" PGUID 0 b t f 18 18 16 631 632 0 0 chargt intltsel intltjoingsel )); DATA(insert OID = 634 ( ">=" PGUID 0 b t f 18 18 16 632 631 0 0 charge intltsel intltjoingsel )); d254 1 a254 1 DATA(insert OID = 660 ( "<" PGUID 0 b t f 19 19 16 662 663 0 0 char16lt intltsel inltjoinsel )); @ 1.20 log @initial load of stuff for ACLs @ text @d14 1 a14 1 * $Header: /usr/local/dev/postgres/newtree/src/backend/catalog/RCS/pg_operator.h,v 1.19 1992/08/21 05:41:01 mer Exp $ d161 2 a162 2 DATA(insert OID = 548 ( "%" 0 0 b t f 21 23 23 6 0 0 0 int24mod intltsel intltjoinsel )); DATA(insert OID = 549 ( "%" 0 0 b t f 23 21 23 6 0 0 0 int42mod intltsel intltjoinsel )); d261 4 a264 4 DATA(insert OID = 671 ( "!=" PGUID 0 b t f 701 701 16 671 670 0 0 float8ne eqsel eqjoinsel )); DATA(insert OID = 672 ( "<" PGUID 0 b t f 701 701 16 674 675 0 0 float8lt intltsel intltjoinsel )); DATA(insert OID = 673 ( "<=" PGUID 0 b t f 701 701 16 675 674 0 0 float8le intltsel intltjoinsel )); DATA(insert OID = 674 ( ">" PGUID 0 b t f 701 701 16 672 673 0 0 float8gt intltsel intltjoinsel )); @ 1.19 log @#define the equal operator oid for booleans needed in selectivity computation @ text @d14 1 a14 1 * $Header: /private/mer/pg/src/lib/H/catalog/RCS/pg_operator.h,v 1.18 1992/08/16 03:38:36 mer Exp mer $ d87 2 a88 2 DATA(insert OID = 85 ( "!=" 6 0 b t t 16 16 16 85 91 0 0 boolne neqsel neqjoinsel )); DATA(insert OID = 91 ( "=" 6 0 b t t 16 16 16 91 85 0 0 booleq eqsel eqjoinsel )); d91 70 a160 70 DATA(insert OID = 92 ( "=" 6 0 b t t 18 18 16 92 630 0 0 chareq eqsel eqjoinsel )); DATA(insert OID = 93 ( "=" 6 0 b t t 19 19 16 93 0 0 0 char16eq eqsel eqjoinsel )); DATA(insert OID = 94 ( "=" 6 0 b t t 21 21 16 94 519 95 95 int2eq eqsel eqjoinsel )); DATA(insert OID = 95 ( "<" 6 0 b t f 21 21 16 520 524 0 0 int2lt intltsel intltjoinsel )); DATA(insert OID = 96 ( "=" 6 0 b t t 23 23 16 96 518 97 97 int4eq eqsel eqjoinsel )); DATA(insert OID = 97 ( "<" 6 0 b t f 23 23 16 521 525 0 0 int4lt intltsel intltjoinsel )); DATA(insert OID = 98 ( "=" 6 0 b t t 25 25 16 98 531 0 0 texteq eqsel eqjoinsel )); DATA(insert OID = 485 ( "<<" 6 0 b t f 604 604 16 0 0 0 0 poly_left intltsel intltjoinsel )); DATA(insert OID = 486 ( "&<" 6 0 b t f 604 604 16 0 0 0 0 poly_overleft intltsel intltjoinsel )); DATA(insert OID = 487 ( "&>" 6 0 b t f 604 604 16 0 0 0 0 poly_overright intltsel intltjoinsel )); DATA(insert OID = 488 ( ">>" 6 0 b t f 604 604 16 0 0 0 0 poly_right intltsel intltjoinsel )); DATA(insert OID = 489 ( "@@" 6 0 b t f 604 604 16 0 0 0 0 poly_contained intltsel intltjoinsel )); DATA(insert OID = 490 ( "~" 6 0 b t f 604 604 16 0 0 0 0 poly_contain intltsel intltjoinsel )); DATA(insert OID = 491 ( "~=" 6 0 b t f 604 604 16 0 0 0 0 poly_same intltsel intltjoinsel )); DATA(insert OID = 492 ( "&&" 6 0 b t f 604 604 16 0 0 0 0 poly_overlap intltsel intltjoinsel )); DATA(insert OID = 493 ( "<<" 6 0 b t f 603 603 16 0 0 0 0 box_left intltsel intltjoinsel )); DATA(insert OID = 494 ( "&<" 6 0 b t f 603 603 16 0 0 0 0 box_overleft intltsel intltjoinsel )); DATA(insert OID = 495 ( "&>" 6 0 b t f 603 603 16 0 0 0 0 box_overright intltsel intltjoinsel )); DATA(insert OID = 496 ( ">>" 6 0 b t f 603 603 16 0 0 0 0 box_right intltsel intltjoinsel )); DATA(insert OID = 497 ( "@@" 6 0 b t f 603 603 16 0 0 0 0 box_contained intltsel intltjoinsel )); DATA(insert OID = 498 ( "~" 6 0 b t f 603 603 16 0 0 0 0 box_contain intltsel intltjoinsel )); DATA(insert OID = 499 ( "~=" 6 0 b t f 603 603 16 0 0 0 0 box_same intltsel intltjoinsel )); DATA(insert OID = 500 ( "&&" 6 0 b t f 603 603 16 0 0 0 0 box_overlap intltsel intltjoinsel )); DATA(insert OID = 501 ( ">=" 6 0 b t f 603 603 16 0 0 0 0 box_ge areasel areajoinsel )); DATA(insert OID = 502 ( ">" 6 0 b t f 603 603 16 0 0 0 0 box_gt areasel areajoinsel )); DATA(insert OID = 503 ( "=" 6 0 b t t 603 603 16 0 0 0 0 box_eq areasel areajoinsel )); DATA(insert OID = 504 ( "<" 6 0 b t f 603 603 16 0 0 0 0 box_lt areasel areajoinsel )); DATA(insert OID = 505 ( "<=" 6 0 b t f 603 603 16 0 0 0 0 box_le areasel areajoinsel )); DATA(insert OID = 506 ( "!^" 6 0 b t f 600 600 16 0 0 0 0 point_above intltsel intltjoinsel )); DATA(insert OID = 507 ( "!<" 6 0 b t f 600 600 16 0 0 0 0 point_left intltsel intltjoinsel )); DATA(insert OID = 508 ( "!>" 6 0 b t f 600 600 16 0 0 0 0 point_right intltsel intltjoinsel )); DATA(insert OID = 509 ( "!|" 6 0 b t f 600 600 16 0 0 0 0 point_below intltsel intltjoinsel )); DATA(insert OID = 510 ( "=|=" 6 0 b t f 600 600 16 0 0 0 0 point_eq intltsel intltjoinsel )); DATA(insert OID = 511 ( "--->" 6 0 b t f 600 603 16 0 0 0 0 on_pb intltsel intltjoinsel )); DATA(insert OID = 512 ( "---`" 6 0 b t f 600 602 16 0 0 0 0 on_ppath intltsel intltjoinsel )); DATA(insert OID = 513 ( "@@@@" 6 0 l t f 0 603 600 0 0 0 0 box_center intltsel intltjoinsel )); DATA(insert OID = 514 ( "*" 6 0 b t f 23 23 23 514 0 0 0 int4mul intltsel intltjoinsel )); DATA(insert OID = 515 ( "!" 6 0 r t f 23 0 23 0 0 0 0 int4fac intltsel intltjoinsel )); DATA(insert OID = 516 ( "!!" 6 0 l t f 0 23 23 0 0 0 0 int4fac intltsel intltjoinsel )); DATA(insert OID = 517 ( "<--->" 6 0 b t f 600 600 23 0 0 0 0 pointdist intltsel intltjoinsel )); DATA(insert OID = 518 ( "!=" 6 0 b t f 23 23 16 518 96 0 0 int4ne neqsel neqjoinsel )); DATA(insert OID = 519 ( "!=" 6 0 b t f 21 21 16 519 94 0 0 int2ne neqsel neqjoinsel )); DATA(insert OID = 520 ( ">" 6 0 b t f 21 21 16 95 0 0 0 int2gt intgtsel intgtjoinsel )); DATA(insert OID = 521 ( ">" 6 0 b t f 23 23 16 97 0 0 0 int4gt intgtsel intgtjoinsel )); DATA(insert OID = 522 ( "<=" 6 0 b t f 21 21 16 524 520 0 0 int2le intltsel intltjoinsel )); DATA(insert OID = 523 ( "<=" 6 0 b t f 23 23 16 525 521 0 0 int4le intltsel intltjoinsel )); DATA(insert OID = 524 ( ">=" 6 0 b t f 21 21 16 522 95 0 0 int2ge intgtsel intgtjoinsel )); DATA(insert OID = 525 ( ">=" 6 0 b t f 23 23 16 523 97 0 0 int4ge intgtsel intgtjoinsel )); DATA(insert OID = 526 ( "*" 6 0 b t f 21 21 21 526 0 0 0 int2mul intltsel intltjoinsel )); DATA(insert OID = 527 ( "/" 6 0 b t f 21 21 21 0 0 0 0 int2div intltsel intltjoinsel )); DATA(insert OID = 528 ( "/" 6 0 b t f 23 23 23 0 0 0 0 int4div intltsel intltjoinsel )); DATA(insert OID = 529 ( "%" 6 0 b t f 21 21 21 6 0 0 0 int2mod intltsel intltjoinsel )); DATA(insert OID = 530 ( "%" 6 0 b t f 23 23 23 6 0 0 0 int4mod intltsel intltjoinsel )); DATA(insert OID = 531 ( "!=" 6 0 b t f 25 25 16 531 98 0 0 textne neqsel neqjoinsel )); DATA(insert OID = 532 ( "=" 6 0 b t t 21 23 16 533 538 95 97 int24eq eqsel eqjoinsel )); DATA(insert OID = 533 ( "=" 6 0 b t t 23 21 16 532 539 97 95 int42eq eqsel eqjoinsel )); DATA(insert OID = 534 ( "<" 6 0 b t f 21 23 16 537 542 0 0 int24lt intltsel intltjoinsel )); DATA(insert OID = 535 ( "<" 6 0 b t f 23 21 16 536 543 0 0 int42lt intltsel intltjoinsel )); DATA(insert OID = 536 ( ">" 6 0 b t f 21 23 16 535 540 0 0 int24gt intgtsel intgtjoinsel )); DATA(insert OID = 537 ( ">" 6 0 b t f 23 21 16 534 541 0 0 int42lt intgtsel intgtjoinsel )); DATA(insert OID = 538 ( "!=" 6 0 b t f 21 23 16 539 532 0 0 int24ne neqsel neqjoinsel )); DATA(insert OID = 539 ( "!=" 6 0 b t f 23 21 16 538 533 0 0 int42ne neqsel neqjoinsel )); DATA(insert OID = 540 ( "<=" 6 0 b t f 21 23 16 543 536 0 0 int24le intltsel intltjoinsel )); DATA(insert OID = 541 ( "<=" 6 0 b t f 23 21 16 542 537 0 0 int42le intltsel intltjoinsel )); DATA(insert OID = 542 ( ">=" 6 0 b t f 21 23 16 541 534 0 0 int24ge intgtsel intgtjoinsel )); DATA(insert OID = 543 ( ">=" 6 0 b t f 23 21 16 540 535 0 0 int42ge intgtsel intgtjoinsel )); DATA(insert OID = 544 ( "*" 6 0 b t f 21 23 23 545 0 0 0 int24mul intltsel intltjoinsel )); DATA(insert OID = 545 ( "*" 6 0 b t f 23 21 23 544 0 0 0 int42mul intltsel intltjoinsel )); DATA(insert OID = 546 ( "/" 6 0 b t f 21 23 23 0 0 0 0 int24div intltsel intltjoinsel )); DATA(insert OID = 547 ( "/" 6 0 b t f 23 21 23 0 0 0 0 int42div intltsel intltjoinsel )); d163 71 a233 71 DATA(insert OID = 550 ( "+" 6 0 b t f 21 21 21 550 0 0 0 int2pl intltsel intltjoinsel )); DATA(insert OID = 551 ( "+" 6 0 b t f 23 23 23 551 0 0 0 int4pl intltsel intltjoinsel )); DATA(insert OID = 552 ( "+" 6 0 b t f 21 23 23 553 0 0 0 int24pl intltsel intltjoinsel )); DATA(insert OID = 553 ( "+" 6 0 b t f 23 21 23 552 0 0 0 int42pl intltsel intltjoinsel )); DATA(insert OID = 554 ( "-" 6 0 b t f 21 21 21 0 0 0 0 int2mi intltsel intltjoinsel )); DATA(insert OID = 555 ( "-" 6 0 b t f 23 23 23 0 0 0 0 int4mi intltsel intltjoinsel )); DATA(insert OID = 556 ( "-" 6 0 b t f 21 23 23 0 0 0 0 int24mi intltsel intltjoinsel )); DATA(insert OID = 557 ( "-" 6 0 b t f 23 21 23 0 0 0 0 int42mi intltsel intltjoinsel )); DATA(insert OID = 0 ( "-" 6 0 l t f 0 23 23 0 0 0 0 int4um intltsel intltjoinsel )); DATA(insert OID = 0 ( "-" 6 0 l t f 0 21 21 0 0 0 0 int2um intltsel intltjoinsel )); DATA(insert OID = 558 ( "=" 6 0 b t t 26 26 16 558 559 0 0 oideq intltsel intltjoinsel )); DATA(insert OID = 559 ( "!=" 6 0 b t f 26 26 16 559 558 0 0 oidneq neqsel neqjoinsel )); DATA(insert OID = 560 ( "=" 6 0 b t t 702 702 16 560 561 562 562 abstimeeq eqsel eqjoinsel )); DATA(insert OID = 561 ( "!=" 6 0 b t f 702 702 16 561 560 0 0 abstimene neqsel neqjoinsel )); DATA(insert OID = 562 ( "<" 6 0 b t f 702 702 16 563 565 0 0 abstimelt intltsel intltjoinsel )); DATA(insert OID = 563 ( ">" 6 0 b t f 702 702 16 562 564 0 0 abstimegt intltsel intltjoinsel )); DATA(insert OID = 564 ( "<=" 6 0 b t f 702 702 16 565 563 0 0 abstimele intltsel intltjoinsel )); DATA(insert OID = 565 ( ">=" 6 0 b t f 702 702 16 564 562 0 0 abstimege intltsel intltjoinsel )); DATA(insert OID = 566 ( "=" 6 0 b t t 703 703 16 566 567 568 568 reltimeeq - - )); DATA(insert OID = 567 ( "!=" 6 0 b t f 703 703 16 567 566 0 0 reltimene - - )); DATA(insert OID = 568 ( "<" 6 0 b t f 703 703 16 569 571 0 0 reltimelt - - )); DATA(insert OID = 569 ( ">" 6 0 b t f 703 703 16 568 570 0 0 reltimegt - - )); DATA(insert OID = 570 ( "<=" 6 0 b t f 703 703 16 571 569 0 0 reltimele - - )); DATA(insert OID = 571 ( ">=" 6 0 b t f 703 703 16 570 568 0 0 reltimege - - )); DATA(insert OID = 572 ( "=" 6 0 b t t 704 704 16 572 0 0 0 intervaleq - - )); DATA(insert OID = 573 ( "<<" 6 0 b t f 704 704 16 0 0 0 0 intervalct - - )); DATA(insert OID = 574 ( "&&" 6 0 b t f 704 704 16 0 0 0 0 intervalov - - )); DATA(insert OID = 575 ( "#=" 6 0 b t f 704 703 16 0 576 0 568 intervalleneq - - )); DATA(insert OID = 576 ( "#!=" 6 0 b t f 704 703 16 0 575 0 568 intervallenne - - )); DATA(insert OID = 577 ( "#<" 6 0 b t f 704 703 16 0 580 0 568 intervallenlt - - )); DATA(insert OID = 578 ( "#>" 6 0 b t f 704 703 16 0 579 0 568 intervallengt - - )); DATA(insert OID = 579 ( "#<=" 6 0 b t f 704 703 16 0 578 0 568 intervallenle - - )); DATA(insert OID = 580 ( "#>=" 6 0 b t f 704 703 16 0 577 0 568 intervallenge - - )); DATA(insert OID = 581 ( "+" 6 0 b t f 702 703 702 581 0 0 0 timepl - - )); DATA(insert OID = 582 ( "-" 6 0 b t f 702 703 702 0 0 0 0 timemi - - )); DATA(insert OID = 583 ( "" 6 0 b t f 702 704 16 0 0 562 0 ininterval - - )); DATA(insert OID = 584 ( "-" 6 0 l t f 0 700 700 0 0 0 0 float4um - - )); DATA(insert OID = 585 ( "-" 6 0 l t f 0 701 701 0 0 0 0 float8um - - )); DATA(insert OID = 586 ( "+" 6 0 b t f 700 700 700 586 0 0 0 float4pl - - )); DATA(insert OID = 587 ( "-" 6 0 b t f 700 700 700 0 0 0 0 float4mi - - )); DATA(insert OID = 588 ( "/" 6 0 b t f 700 700 700 0 0 0 0 float4div - - )); DATA(insert OID = 589 ( "*" 6 0 b t f 700 700 700 589 0 0 0 float4mul - - )); DATA(insert OID = 590 ( "@@" 6 0 l t f 0 700 700 0 0 0 0 float4abs - - )); DATA(insert OID = 591 ( "+" 6 0 b t f 701 701 701 591 0 0 0 float8pl - - )); DATA(insert OID = 592 ( "-" 6 0 b t f 701 701 701 0 0 0 0 float8mi - - )); DATA(insert OID = 593 ( "/" 6 0 b t f 701 701 701 0 0 0 0 float8div - - )); DATA(insert OID = 594 ( "*" 6 0 b t f 701 701 701 594 0 0 0 float8mul - - )); DATA(insert OID = 595 ( "@@" 6 0 l t f 0 701 701 0 0 0 0 float8abs - - )); DATA(insert OID = 596 ( "|/" 6 0 l t f 0 701 701 0 0 0 0 dsqrt - - )); DATA(insert OID = 597 ( "||/" 6 0 l t f 0 701 701 0 0 0 0 dcbrt - - )); DATA(insert OID = 598 ( "%" 6 0 l t f 0 701 701 0 0 0 0 dtrunc - - )); DATA(insert OID = 599 ( "%" 6 0 r t f 701 0 701 0 0 0 0 dround - - )); DATA(insert OID = 600 ( "^" 6 0 b t f 701 701 701 0 0 0 0 dpow - - )); DATA(insert OID = 601 ( ":" 6 0 l t f 0 701 701 0 0 0 0 dexp - - )); DATA(insert OID = 602 ( ";" 6 0 l t f 0 701 701 0 0 0 0 dlog1 - - )); DATA(insert OID = 603 ( "|" 6 0 l t f 0 704 702 0 0 0 0 intervalstart - - )); DATA(insert OID = 607 ( "=" 6 0 b t t 26 26 16 607 608 97 97 oideq eqsel eqjoinsel )); DATA(insert OID = 608 ( "!=" 6 0 b t f 26 26 16 608 607 0 0 oidneq eqsel eqjoinsel )); DATA(insert OID = 609 ( "<" 6 0 b t f 26 26 16 610 612 0 0 int4lt intltsel intltjoinsel )); DATA(insert OID = 610 ( ">" 6 0 b t f 26 26 16 609 611 0 0 int4gt intgtsel intgtjoinsel )); DATA(insert OID = 611 ( "<=" 6 0 b t f 26 26 16 612 610 0 0 int4le intltsel intltjoinsel )); DATA(insert OID = 612 ( ">=" 6 0 b t f 26 26 16 611 609 0 0 int4ge intgtsel intgtjoinsel )); DATA(insert OID = 620 ( "=" 6 0 b t t 700 700 16 620 621 622 622 float4eq eqsel eqjoinsel )); DATA(insert OID = 621 ( "!=" 6 0 b t f 700 700 16 621 620 0 0 float4ne eqsel eqjoinsel )); DATA(insert OID = 622 ( "<" 6 0 b t f 700 700 16 623 625 0 0 float4lt intltsel intltjoinsel )); DATA(insert OID = 623 ( ">" 6 0 b t f 700 700 16 622 624 0 0 float4gt intgtsel intgtjoinsel )); DATA(insert OID = 624 ( "<=" 6 0 b t f 700 700 16 625 623 0 0 float4le intltsel intltjoinsel )); DATA(insert OID = 625 ( ">=" 6 0 b t f 700 700 16 624 622 0 0 float4ge intgtsel intgtjoinsel )); DATA(insert OID = 626 ( "!!=" 6 0 b t f 23 19 16 0 0 0 0 int4notin "-" "-")); DATA(insert OID = 627 ( "!!=" 6 0 b t f 26 19 16 0 0 0 0 oidnotin "-" "-")); DATA(insert OID = 630 ( "!=" 6 0 b t f 18 18 16 630 92 0 0 charne eqsel eqjoinsel )); d235 4 a238 4 DATA(insert OID = 631 ( "<" 6 0 b t f 18 18 16 633 634 0 0 charlt intltsel intltjoingsel )); DATA(insert OID = 632 ( "<=" 6 0 b t f 18 18 16 634 633 0 0 charle intltsel intltjoingsel )); DATA(insert OID = 633 ( ">" 6 0 b t f 18 18 16 631 632 0 0 chargt intltsel intltjoingsel )); DATA(insert OID = 634 ( ">=" 6 0 b t f 18 18 16 632 631 0 0 charge intltsel intltjoingsel )); d240 40 a279 40 DATA(insert OID = 635 ( "+" 6 0 b t f 18 18 16 0 0 0 0 charpl eqsel eqjoinsel )); DATA(insert OID = 636 ( "-" 6 0 b t f 18 18 16 0 0 0 0 charmi eqsel eqjoinsel )); DATA(insert OID = 637 ( "*" 6 0 b t f 18 18 16 0 0 0 0 charmul eqsel eqjoinsel )); DATA(insert OID = 638 ( "/" 6 0 b t f 18 18 16 0 0 0 0 chardiv eqsel eqjoinsel )); DATA(insert OID = 639 ( "~" 6 0 b t f 19 19 16 0 640 0 0 char16regexeq eqsel eqjoinsel )); DATA(insert OID = 640 ( "!~" 6 0 b t f 19 19 16 0 639 0 0 char16regexne eqsel eqjoinsel )); DATA(insert OID = 641 ( "~" 6 0 b t f 25 25 16 0 642 0 0 textregexeq eqsel eqjoinsel )); DATA(insert OID = 642 ( "!~" 6 0 b t f 25 25 16 0 641 0 0 textregexne eqsel eqjoinsel )); DATA(insert OID = 643 ( "!=" 6 0 b t f 19 19 16 93 643 0 0 char16ne eqsel eqjoinsel )); DATA(insert OID = 660 ( "<" 6 0 b t f 19 19 16 662 663 0 0 char16lt intltsel inltjoinsel )); DATA(insert OID = 661 ( "<=" 6 0 b t f 19 19 16 663 662 0 0 char16le intltsel intltjoinsel )); DATA(insert OID = 662 ( ">" 6 0 b t f 19 19 16 660 661 0 0 char16gt intltsel intltjoinsel )); DATA(insert OID = 663 ( ">=" 6 0 b t f 19 19 16 661 660 0 0 char16ge intltsel intltjoinsel )); DATA(insert OID = 664 ( "<" 6 0 b t f 25 25 16 666 667 0 0 text_lt intltsel intltjoinsel )); DATA(insert OID = 665 ( "<=" 6 0 b t f 25 25 16 667 666 0 0 text_le intltsel intltjoinsel )); DATA(insert OID = 666 ( ">" 6 0 b t f 25 25 16 664 665 0 0 text_gt intltsel intltjoinsel )); DATA(insert OID = 667 ( ">=" 6 0 b t f 25 25 16 665 664 0 0 text_ge intltsel intltjoinsel )); DATA(insert OID = 670 ( "=" 6 0 b t f 701 701 16 670 671 0 0 float8eq eqsel eqjoinsel )); DATA(insert OID = 671 ( "!=" 6 0 b t f 701 701 16 671 670 0 0 float8ne eqsel eqjoinsel )); DATA(insert OID = 672 ( "<" 6 0 b t f 701 701 16 674 675 0 0 float8lt intltsel intltjoinsel )); DATA(insert OID = 673 ( "<=" 6 0 b t f 701 701 16 675 674 0 0 float8le intltsel intltjoinsel )); DATA(insert OID = 674 ( ">" 6 0 b t f 701 701 16 672 673 0 0 float8gt intltsel intltjoinsel )); DATA(insert OID = 675 ( ">=" 6 0 b t f 701 701 16 673 672 0 0 float8ge intltsel intltjoinsel )); DATA(insert OID = 676 ( "<" 6 0 b t f 910 910 16 680 679 0 0 oidchar16lt intltsel intltjoinsel )); DATA(insert OID = 677 ( "<=" 6 0 b t f 910 910 16 679 680 0 0 oidchar16le intltsel intltjoinsel )); DATA(insert OID = 678 ( "=" 6 0 b t f 910 910 16 678 681 0 0 oidchar16eq intltsel intltjoinsel )); DATA(insert OID = 679 ( ">=" 6 0 b t f 910 910 16 677 676 0 0 oidchar16ge intltsel intltjoinsel )); DATA(insert OID = 680 ( ">" 6 0 b t f 910 910 16 676 677 0 0 oidchar16gt intltsel intltjoinsel )); DATA(insert OID = 681 ( "!=" 6 0 b t f 910 910 16 681 678 0 0 oidchar16ne intltsel intltjoinsel )); DATA(insert OID = 930 ( "<" 6 0 b t f 910 910 16 934 933 0 0 oidint4lt intltsel intltjoinsel )); DATA(insert OID = 931 ( "<=" 6 0 b t f 910 910 16 933 934 0 0 oidint4le intltsel intltjoinsel )); DATA(insert OID = 932 ( "=" 6 0 b t f 910 910 16 932 935 0 0 oidint4eq intltsel intltjoinsel )); DATA(insert OID = 933 ( ">=" 6 0 b t f 910 910 16 931 930 0 0 oidint4ge intltsel intltjoinsel )); DATA(insert OID = 934 ( ">" 6 0 b t f 910 910 16 930 931 0 0 oidint4gt intltsel intltjoinsel )); DATA(insert OID = 935 ( "!=" 6 0 b t f 910 910 16 935 932 0 0 oidint4ne intltsel intltjoinsel )); @ 1.18 log @add != (not equal) operator for boolean @ text @d14 1 a14 1 * $Header: /private/mer/pg/src/lib/H/catalog/RCS/pg_operator.h,v 1.17 1992/07/28 19:12:15 mao Exp mer $ d89 2 @ 1.17 log @add int4, int2 uminus routines @ text @d14 1 a14 1 * $Header: /private/mao/postgres/src/lib/H/catalog/RCS/pg_operator.h,v 1.16 1992/05/05 01:17:23 mer Exp mao $ d87 2 a88 1 DATA(insert OID = 91 ( "=" 6 0 b t t 16 16 16 91 0 0 0 booleq eqsel eqjoinsel )); @ 1.16 log @fix int[24]mod operator definitions @ text @d14 1 a14 1 * $Header: /users/mer/pg/src/lib/H/catalog/RCS/pg_operator.h,v 1.15 1992/03/02 21:23:07 mer Exp mer $ d168 2 @ 1.15 log @new types and opclasses to simulate indices on two attrs using functional indices (types are oidchar16 and oidint4). @ text @d14 1 a14 1 * $Header: /users/mer/pg/src/lib/H/catalog/RCS/pg_operator.h,v 1.14 1991/11/05 06:11:55 mao Exp mer $ d139 2 a140 2 DATA(insert OID = 529 ( "%" 0 b 0 t f 21 21 21 6 0 0 0 int2mod intltsel intltjoinsel )); DATA(insert OID = 530 ( "%" 0 b 0 t f 23 23 23 6 0 0 0 int4mod intltsel intltjoinsel )); @ 1.14 log @support for mao large objects and a new operator class for btrees @ text @d14 1 a14 1 * $Header: /users/mao/postgres/src/lib/H/catalog/RCS/pg_operator.h,v 1.13 1991/05/04 16:19:12 mer Exp mao $ d262 13 a274 6 DATA(insert OID = 930 ( "<" 6 0 b t f 910 910 16 934 933 0 0 oidseqlt intltsel intltjoinsel )); DATA(insert OID = 931 ( "<=" 6 0 b t f 910 910 16 933 934 0 0 oidseqle intltsel intltjoinsel )); DATA(insert OID = 932 ( "=" 6 0 b t f 910 910 16 932 935 0 0 oidseqeq intltsel intltjoinsel )); DATA(insert OID = 933 ( ">=" 6 0 b t f 910 910 16 931 930 0 0 oidseqge intltsel intltjoinsel )); DATA(insert OID = 934 ( ">" 6 0 b t f 910 910 16 930 931 0 0 oidseqgt intltsel intltjoinsel )); DATA(insert OID = 935 ( "!=" 6 0 b t f 910 910 16 935 932 0 0 oidseqne intltsel intltjoinsel )); @ 1.13 log @add polygon support @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.12 91/03/03 19:35:24 mao Exp Locker: mer $ d261 7 @ 1.12 log @add char16ne @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.11 91/03/03 01:24:35 mao Exp Locker: mao $ d95 8 @ 1.11 log @use (more) sensible selectivity functions for char comparison operators @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.10 91/03/03 00:36:29 mao Exp Locker: mao $ d236 1 d238 4 a241 4 DATA(insert OID = 660 ( "<" 6 0 b t f 19 19 16 662 663 0 0 char16lt eqsel eqjoinsel )); DATA(insert OID = 661 ( "<=" 6 0 b t f 19 19 16 663 662 0 0 char16le eqsel eqjoinsel )); DATA(insert OID = 662 ( ">" 6 0 b t f 19 19 16 660 661 0 0 char16gt eqsel eqjoinsel )); DATA(insert OID = 663 ( ">=" 6 0 b t f 19 19 16 661 660 0 0 char16ge eqsel eqjoinsel )); @ 1.10 log @get arbitrary-length index keys working @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.9 91/01/22 19:40:51 mao Exp Locker: mao $ d222 4 a225 4 DATA(insert OID = 631 ( "<" 6 0 b t f 18 18 16 633 634 0 0 charlt eqsel eqjoinsel )); DATA(insert OID = 632 ( "<=" 6 0 b t f 18 18 16 634 633 0 0 charle eqsel eqjoinsel )); DATA(insert OID = 633 ( ">" 6 0 b t f 18 18 16 631 632 0 0 chargt eqsel eqjoinsel )); DATA(insert OID = 634 ( ">=" 6 0 b t f 18 18 16 632 631 0 0 charge eqsel eqjoinsel )); @ 1.9 log @regexp routines are now builtins per stonebraker @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.8 90/10/15 23:25:41 cimarron Exp Locker: mao $ d162 6 a167 6 DATA(insert OID = 560 ( "=" 6 0 b t t 702 702 16 560 561 562 562 abstimeeq - - )); DATA(insert OID = 561 ( "!=" 6 0 b t f 702 702 16 561 560 0 0 abstimene - - )); DATA(insert OID = 562 ( "<" 6 0 b t f 702 702 16 563 565 0 0 abstimelt - - )); DATA(insert OID = 563 ( ">" 6 0 b t f 702 702 16 562 564 0 0 abstimegt - - )); DATA(insert OID = 564 ( "<=" 6 0 b t f 702 702 16 565 563 0 0 abstimele - - )); DATA(insert OID = 565 ( ">=" 6 0 b t f 702 702 16 564 562 0 0 abstimege - - )); d241 12 a252 1 @ 1.8 log @added new system catalog functions for tuple id printing and char16 compairson @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.7 90/10/03 16:31:36 hong Exp Locker: cimarron $ d231 5 @ 1.7 log @for fixes for ">" selectivity @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.6 90/10/03 16:21:43 hong Exp $ d220 7 a226 5 DATA(insert OID = 630 ( "!=" 6 0 b t f 18 18 16 630 92 0 0 charne eqsel eqjoinsel )); DATA(insert OID = 631 ( "<" 6 0 b t f 18 18 16 631 634 0 0 charlt eqsel eqjoinsel )); DATA(insert OID = 632 ( "<=" 6 0 b t f 18 18 16 632 633 0 0 charle eqsel eqjoinsel )); DATA(insert OID = 633 ( ">" 6 0 b t f 18 18 16 633 632 0 0 chargt eqsel eqjoinsel )); DATA(insert OID = 634 ( ">=" 6 0 b t f 18 18 16 634 631 0 0 charge eqsel eqjoinsel )); d232 5 @ 1.6 log @">" now calls the right selectivity functions. @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.5 90/09/20 11:56:41 hong Exp $ d122 2 a123 2 DATA(insert OID = 520 ( ">" 6 0 b t f 21 21 16 95 0 0 0 int2gt intgtsel intltjoinsel )); DATA(insert OID = 521 ( ">" 6 0 b t f 23 23 16 97 0 0 0 int4gt intgtsel intltjoinsel )); d126 2 a127 2 DATA(insert OID = 524 ( ">=" 6 0 b t f 21 21 16 522 95 0 0 int2ge intgtsel intltjoinsel )); DATA(insert OID = 525 ( ">=" 6 0 b t f 23 23 16 523 97 0 0 int4ge intgtsel intltjoinsel )); d209 1 a209 1 DATA(insert OID = 610 ( ">" 6 0 b t f 26 26 16 609 611 0 0 int4gt intgtsel intltjoinsel )); d211 1 a211 1 DATA(insert OID = 612 ( ">=" 6 0 b t f 26 26 16 611 609 0 0 int4ge intgtsel intltjoinsel )); d215 1 a215 1 DATA(insert OID = 623 ( ">" 6 0 b t f 700 700 16 622 624 0 0 float4gt intgtsel intltjoinsel )); d217 1 a217 1 DATA(insert OID = 625 ( ">=" 6 0 b t f 700 700 16 624 622 0 0 float4ge intgtsel intltjoinsel )); @ 1.5 log @turned off mergesort for non-equi operators @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.4 90/08/17 08:51:38 cimarron Exp Locker: hong $ d122 2 a123 2 DATA(insert OID = 520 ( ">" 6 0 b t f 21 21 16 95 0 0 0 int2gt intltsel intltjoinsel )); DATA(insert OID = 521 ( ">" 6 0 b t f 23 23 16 97 0 0 0 int4gt intltsel intltjoinsel )); d126 2 a127 2 DATA(insert OID = 524 ( ">=" 6 0 b t f 21 21 16 522 95 0 0 int2ge intltsel intltjoinsel )); DATA(insert OID = 525 ( ">=" 6 0 b t f 23 23 16 523 97 0 0 int4ge intltsel intltjoinsel )); d209 1 a209 1 DATA(insert OID = 610 ( ">" 6 0 b t f 26 26 16 609 611 0 0 int4gt intltsel intltjoinsel )); d211 1 a211 1 DATA(insert OID = 612 ( ">=" 6 0 b t f 26 26 16 611 609 0 0 int4ge intltsel intltjoinsel )); d215 1 a215 1 DATA(insert OID = 623 ( ">" 6 0 b t f 700 700 16 622 624 0 0 float4gt intltsel intltjoinsel )); d217 1 a217 1 DATA(insert OID = 625 ( ">=" 6 0 b t f 700 700 16 624 622 0 0 float4ge intltsel intltjoinsel )); @ 1.4 log @added pathnames to #include statements @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.3 90/08/08 08:19:51 cimarron Exp Locker: cimarron $ d91 1 a91 1 DATA(insert OID = 95 ( "<" 6 0 b t f 21 21 16 520 524 95 95 int2lt intltsel intltjoinsel )); d93 1 a93 1 DATA(insert OID = 97 ( "<" 6 0 b t f 23 23 16 521 525 97 97 int4lt intltsel intltjoinsel )); d120 13 a132 13 DATA(insert OID = 518 ( "!=" 6 0 b t f 23 23 16 518 96 97 97 int4ne neqsel neqjoinsel )); DATA(insert OID = 519 ( "!=" 6 0 b t f 21 21 16 519 94 95 95 int2ne neqsel neqjoinsel )); DATA(insert OID = 520 ( ">" 6 0 b t f 21 21 16 95 0 95 95 int2gt intltsel intltjoinsel )); DATA(insert OID = 521 ( ">" 6 0 b t f 23 23 16 97 0 97 97 int4gt intltsel intltjoinsel )); DATA(insert OID = 522 ( "<=" 6 0 b t f 21 21 16 524 520 95 95 int2le intltsel intltjoinsel )); DATA(insert OID = 523 ( "<=" 6 0 b t f 23 23 16 525 521 97 97 int4le intltsel intltjoinsel )); DATA(insert OID = 524 ( ">=" 6 0 b t f 21 21 16 522 95 95 95 int2ge intltsel intltjoinsel )); DATA(insert OID = 525 ( ">=" 6 0 b t f 23 23 16 523 97 97 97 int4ge intltsel intltjoinsel )); DATA(insert OID = 526 ( "*" 6 0 b t f 21 21 21 526 0 95 95 int2mul intltsel intltjoinsel )); DATA(insert OID = 527 ( "/" 6 0 b t f 21 21 21 0 0 95 95 int2div intltsel intltjoinsel )); DATA(insert OID = 528 ( "/" 6 0 b t f 23 23 23 0 0 97 97 int4div intltsel intltjoinsel )); DATA(insert OID = 529 ( "%" 0 b 0 t f 21 21 21 6 0 95 95 int2mod intltsel intltjoinsel )); DATA(insert OID = 530 ( "%" 0 b 0 t f 23 23 23 6 0 97 97 int4mod intltsel intltjoinsel )); d136 16 a151 16 DATA(insert OID = 534 ( "<" 6 0 b t f 21 23 16 537 542 95 97 int24lt intltsel intltjoinsel )); DATA(insert OID = 535 ( "<" 6 0 b t f 23 21 16 536 543 97 95 int42lt intltsel intltjoinsel )); DATA(insert OID = 536 ( ">" 6 0 b t f 21 23 16 535 540 95 97 int24gt intgtsel intgtjoinsel )); DATA(insert OID = 537 ( ">" 6 0 b t f 23 21 16 534 541 97 95 int42lt intgtsel intgtjoinsel )); DATA(insert OID = 538 ( "!=" 6 0 b t f 21 23 16 539 532 95 97 int24ne neqsel neqjoinsel )); DATA(insert OID = 539 ( "!=" 6 0 b t f 23 21 16 538 533 97 95 int42ne neqsel neqjoinsel )); DATA(insert OID = 540 ( "<=" 6 0 b t f 21 23 16 543 536 95 97 int24le intltsel intltjoinsel )); DATA(insert OID = 541 ( "<=" 6 0 b t f 23 21 16 542 537 97 95 int42le intltsel intltjoinsel )); DATA(insert OID = 542 ( ">=" 6 0 b t f 21 23 16 541 534 95 97 int24ge intgtsel intgtjoinsel )); DATA(insert OID = 543 ( ">=" 6 0 b t f 23 21 16 540 535 97 95 int42ge intgtsel intgtjoinsel )); DATA(insert OID = 544 ( "*" 6 0 b t f 21 23 23 545 0 95 97 int24mul intltsel intltjoinsel )); DATA(insert OID = 545 ( "*" 6 0 b t f 23 21 23 544 0 97 95 int42mul intltsel intltjoinsel )); DATA(insert OID = 546 ( "/" 6 0 b t f 21 23 23 0 0 95 97 int24div intltsel intltjoinsel )); DATA(insert OID = 547 ( "/" 6 0 b t f 23 21 23 0 0 97 95 int42div intltsel intltjoinsel )); DATA(insert OID = 548 ( "%" 0 0 b t f 21 23 23 6 0 95 97 int24mod intltsel intltjoinsel )); DATA(insert OID = 549 ( "%" 0 0 b t f 23 21 23 6 0 97 95 int42mod intltsel intltjoinsel )); d163 5 a167 5 DATA(insert OID = 561 ( "!=" 6 0 b t f 702 702 16 561 560 562 562 abstimene - - )); DATA(insert OID = 562 ( "<" 6 0 b t f 702 702 16 563 565 562 562 abstimelt - - )); DATA(insert OID = 563 ( ">" 6 0 b t f 702 702 16 562 564 562 562 abstimegt - - )); DATA(insert OID = 564 ( "<=" 6 0 b t f 702 702 16 565 563 562 562 abstimele - - )); DATA(insert OID = 565 ( ">=" 6 0 b t f 702 702 16 564 562 562 562 abstimege - - )); d169 5 a173 5 DATA(insert OID = 567 ( "!=" 6 0 b t f 703 703 16 567 566 568 568 reltimene - - )); DATA(insert OID = 568 ( "<" 6 0 b t f 703 703 16 569 571 568 568 reltimelt - - )); DATA(insert OID = 569 ( ">" 6 0 b t f 703 703 16 568 570 568 568 reltimegt - - )); DATA(insert OID = 570 ( "<=" 6 0 b t f 703 703 16 571 569 568 568 reltimele - - )); DATA(insert OID = 571 ( ">=" 6 0 b t f 703 703 16 570 568 568 568 reltimege - - )); d183 2 a184 2 DATA(insert OID = 581 ( "+" 6 0 b t f 702 703 702 581 0 562 562 timepl - - )); DATA(insert OID = 582 ( "-" 6 0 b t f 702 703 702 0 0 562 568 timemi - - )); d207 5 a211 5 DATA(insert OID = 608 ( "!=" 6 0 b t f 26 26 16 608 607 97 97 oidneq eqsel eqjoinsel )); DATA(insert OID = 609 ( "<" 6 0 b t f 26 26 16 610 612 97 97 int4lt intltsel intltjoinsel )); DATA(insert OID = 610 ( ">" 6 0 b t f 26 26 16 609 611 97 97 int4gt intltsel intltjoinsel )); DATA(insert OID = 611 ( "<=" 6 0 b t f 26 26 16 612 610 97 97 int4le intltsel intltjoinsel )); DATA(insert OID = 612 ( ">=" 6 0 b t f 26 26 16 611 609 97 97 int4ge intltsel intltjoinsel )); d213 5 a217 5 DATA(insert OID = 621 ( "!=" 6 0 b t f 700 700 16 621 620 622 622 float4ne eqsel eqjoinsel )); DATA(insert OID = 622 ( "<" 6 0 b t f 700 700 16 623 625 622 622 float4lt intltsel intltjoinsel )); DATA(insert OID = 623 ( ">" 6 0 b t f 700 700 16 622 624 622 622 float4gt intltsel intltjoinsel )); DATA(insert OID = 624 ( "<=" 6 0 b t f 700 700 16 625 623 622 622 float4le intltsel intltjoinsel )); DATA(insert OID = 625 ( ">=" 6 0 b t f 700 700 16 624 622 622 622 float4ge intltsel intltjoinsel )); @ 1.3 log @reorganized some header files @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.2 90/08/01 13:37:59 hong Exp Locker: cimarron $ d26 1 a26 1 #include "postgres.h" @ 1.2 log @to make all the equality operators hashjoinable @ text @d14 1 a14 1 * $Header: RCS/pg_operator.h,v 1.1 90/06/18 16:16:32 cimarron Version_2 Locker: hong $ d21 3 a23 3 * catmacros.h defines the CATALOG(), BOOTSTRAP and * DATA() sugar words so this file can be read by both * genbki.sh and the C compiler. d26 1 a26 1 #include "catalog/catmacros.h" @ 1.1 log @Initial version. The new setup is for lib/H/catalog to contain a pg_xxx.h file for each pg_xxx database in the system catalogs. This .h file contains CATALOG() and DATA() statements used to generate typedefs for the catalog tuple structures as well as initialization scripts for createdb. @ text @d14 1 a14 1 * $Header$ d87 4 a90 4 DATA(insert OID = 91 ( "=" 6 0 b t f 16 16 16 91 0 0 0 booleq eqsel eqjoinsel )); DATA(insert OID = 92 ( "=" 6 0 b t f 18 18 16 92 630 0 0 chareq eqsel eqjoinsel )); DATA(insert OID = 93 ( "=" 6 0 b t f 19 19 16 93 0 0 0 char16eq eqsel eqjoinsel )); DATA(insert OID = 94 ( "=" 6 0 b t f 21 21 16 94 519 95 95 int2eq eqsel eqjoinsel )); d92 1 a92 1 DATA(insert OID = 96 ( "=" 6 0 b t f 23 23 16 96 518 97 97 int4eq eqsel eqjoinsel )); d94 1 a94 1 DATA(insert OID = 98 ( "=" 6 0 b t f 25 25 16 98 531 0 0 texteq eqsel eqjoinsel )); d105 1 a105 1 DATA(insert OID = 503 ( "=" 6 0 b t f 603 603 16 0 0 0 0 box_eq areasel areajoinsel )); d134 2 a135 2 DATA(insert OID = 532 ( "=" 6 0 b t f 21 23 16 533 538 95 97 int24eq eqsel eqjoinsel )); DATA(insert OID = 533 ( "=" 6 0 b t f 23 21 16 532 539 97 95 int42eq eqsel eqjoinsel )); d160 1 a160 1 DATA(insert OID = 558 ( "=" 6 0 b t f 26 26 16 558 559 0 0 oideq intltsel intltjoinsel )); d162 1 a162 1 DATA(insert OID = 560 ( "=" 6 0 b t f 702 702 16 560 561 562 562 abstimeeq - - )); d168 1 a168 1 DATA(insert OID = 566 ( "=" 6 0 b t f 703 703 16 566 567 568 568 reltimeeq - - )); d174 1 a174 1 DATA(insert OID = 572 ( "=" 6 0 b t f 704 704 16 572 0 0 0 intervaleq - - )); d206 1 a206 1 DATA(insert OID = 607 ( "=" 6 0 b t f 26 26 16 607 608 97 97 oideq eqsel eqjoinsel )); d212 1 a212 1 DATA(insert OID = 620 ( "=" 6 0 b t f 700 700 16 620 621 622 622 float4eq eqsel eqjoinsel )); @