77 *
88 * Copyright (c) 1994, Regents of the University of California
99 *
10- * $Id: pg_operator.h,v 1.19 1997/11/1805:22:49 momjian Exp $
10+ * $Id: pg_operator.h,v 1.20 1997/11/1806:46:31 momjian Exp $
1111 *
1212 * NOTES
1313 * the genbki.sh script reads this file and generates .bki
@@ -450,7 +450,7 @@ DESCR("truncate to integer");
450450DATA (insert OID = 1282 (":" PGUID 0 l t f 0 701 701 0 0 0 0 dexp - - ));
451451DESCR ("exponential" );
452452DATA (insert OID = 1283 (";" PGUID 0 l t f 0 701 701 0 0 0 0 dlog1 - - ));
453- DESCR ("natural logarith (in psql, protect withparentheses) " );
453+ DESCR ("natural logarith (in psql, protect with'()' " );
454454DATA (insert OID = 1284 ("|" PGUID 0 l t f 0 704 702 0 0 0 0 intervalstart - - ));
455455DESCR ("start of interval" );
456456DATA (insert OID = 606 ("<#>" PGUID 0 b t f 702 702 704 0 0 0 0 mktinterval - - ));
@@ -524,13 +524,13 @@ DATA(insert OID = 638 ( "/" PGUID 0 b t f 18 18 18 0 0 0 0 chardiv eqsel
524524DESCR ("divide" );
525525
526526DATA (insert OID = 639 ("~" PGUID 0 b t f 19 25 16 0 640 0 0 nameregexeq eqsel eqjoinsel ));
527- DESCR ("matchesregular expression , case-sensitive" );
527+ DESCR ("matchesregex. , case-sensitive" );
528528DATA (insert OID = 640 ("!~" PGUID 0 b t f 19 25 16 0 639 0 0 nameregexne neqsel neqjoinsel ));
529- DESCR ("does not matchregular expression , case-sensitive" );
529+ DESCR ("does not matchregex. , case-sensitive" );
530530DATA (insert OID = 641 ("~" PGUID 0 b t f 25 25 16 0 642 0 0 textregexeq eqsel eqjoinsel ));
531- DESCR ("matchesregular expression , case-sensitive" );
531+ DESCR ("matchesregex. , case-sensitive" );
532532DATA (insert OID = 642 ("!~" PGUID 0 b t f 25 25 16 0 641 0 0 textregexne eqsel eqjoinsel ));
533- DESCR ("does not matchregular expression , case-sensitive" );
533+ DESCR ("does not matchregex. , case-sensitive" );
534534DATA (insert OID = 643 ("<>" PGUID 0 b t f 19 19 16 643 93 0 0 namene neqsel neqjoinsel ));
535535DESCR ("not equal" );
536536DATA (insert OID = 644 ("<>" PGUID 0 b t f 20 20 16 644 1267 0 0 char16ne neqsel neqjoinsel ));
@@ -544,9 +544,9 @@ DESCR("greater-than");
544544DATA (insert OID = 648 (">=" PGUID 0 b t f 20 20 16 646 645 0 0 char16ge intltsel intltjoinsel ));
545545DESCR ("greater-than-or-equals" );
546546DATA (insert OID = 649 ("~" PGUID 0 b t f 20 25 16 0 650 0 0 char16regexeq intltsel intltjoinsel ));
547- DESCR ("matchesregular expression , case-sensitive" );
547+ DESCR ("matchesregex. , case-sensitive" );
548548DATA (insert OID = 650 ("!~" PGUID 0 b t f 20 25 16 650 0 0 0 char16regexne intltsel intltjoinsel ));
549- DESCR ("does not matchregular expression , case-sensitive" );
549+ DESCR ("does not matchregex. , case-sensitive" );
550550DATA (insert OID = 651 ("~~" PGUID 0 b t f 20 25 16 0 651 0 0 char16like eqsel eqjoinsel ));
551551DESCR ("matches LIKE expression" );
552552DATA (insert OID = 652 ("!~~" PGUID 0 b t f 20 25 16 651 0 0 0 char16nlike neqsel neqjoinsel ));
@@ -598,9 +598,9 @@ DATA(insert OID = 681 ( "<>" PGUID 0 b t f 911 91116 681 6780 0 oidnamen
598598DESCR ("not equal" );
599599
600600DATA (insert OID = 697 ("~" PGUID 0 b t f 411 25 16 0 698 0 0 char8regexeq eqsel eqjoinsel ));
601- DESCR ("matchesregular expression , case-sensitive" );
601+ DESCR ("matchesregex. , case-sensitive" );
602602DATA (insert OID = 698 ("!~" PGUID 0 b t f 411 25 16 0 697 0 0 char8regexne neqsel neqjoinsel ));
603- DESCR ("does not matchregular expression , case-sensitive" );
603+ DESCR ("does not matchregex. , case-sensitive" );
604604
605605DATA (insert OID = 706 ("<->" PGUID 0 b t f 603 603 701 706 0 0 0 box_distance intltsel intltjoinsel ));
606606DESCR ("distance between" );
@@ -710,13 +710,13 @@ DATA(insert OID = 835 ( "<>" PGUID 0 b t f 810 81016 835 8320 0 oidint2n
710710DESCR ("not equal" );
711711
712712DATA (insert OID = 839 ("~" PGUID 0 b t f 409 25 16 0 841 0 0 char2regexeq eqsel eqjoinsel ));
713- DESCR ("matchesregular expression , case-sensitive" );
713+ DESCR ("matchesregex. , case-sensitive" );
714714DATA (insert OID = 841 ("!~" PGUID 0 b t f 409 25 16 0 839 0 0 char2regexne neqsel neqjoinsel ));
715- DESCR ("does not matchregular expression , case-sensitive" );
715+ DESCR ("does not matchregex. , case-sensitive" );
716716DATA (insert OID = 840 ("~" PGUID 0 b t f 410 25 16 0 842 0 0 char4regexeq eqsel eqjoinsel ));
717- DESCR ("matchesregular expression , case-sensitive" );
717+ DESCR ("matchesregex. , case-sensitive" );
718718DATA (insert OID = 842 ("!~" PGUID 0 b t f 410 25 16 0 840 0 0 char4regexne neqsel neqjoinsel ));
719- DESCR ("does not matchregular expression , case-sensitive" );
719+ DESCR ("does not matchregex. , case-sensitive" );
720720
721721DATA (insert OID = 843 ("*" PGUID 0 b t f 790 700 790 845 0 0 0 cash_mul_flt4 - - ));
722722DESCR ("multiply" );
@@ -780,7 +780,7 @@ DESCR("addition");
780780DATA (insert OID = 967 ("-" PGUID 0 b t f 1034 1033 1034 0 0 0 0 aclremove intltsel intltjoinsel ));
781781DESCR ("subtract" );
782782DATA (insert OID = 968 ("~" PGUID 0 b t f 1034 1033 16 0 0 0 0 aclcontains intltsel intltjoinsel ));
783- DESCR ("matchesregular expression , case-sensitive" );
783+ DESCR ("matchesregex. , case-sensitive" );
784784
785785/* additional geometric operators - thomas 1997-07-09 */
786786DATA (insert OID = 969 ("@@" PGUID 0 l t f 0 601 600 0 0 0 0 lseg_center - - ));
@@ -798,9 +798,9 @@ DESCR("concat");
798798DATA (insert OID = 1054 ("=" PGUID 0 b t t 1042 1042 16 1054 1057 1058 1058 bpchareq eqsel eqjoinsel ));
799799DESCR ("equals" );
800800DATA (insert OID = 1055 ("~" PGUID 0 b t f 1042 25 16 0 1056 0 0 textregexeq eqsel eqjoinsel ));
801- DESCR ("matchesregular expression , case-sensitive" );
801+ DESCR ("matchesregex. , case-sensitive" );
802802DATA (insert OID = 1056 ("!~" PGUID 0 b t f 1042 25 16 0 1055 0 0 textregexne neqsel neqjoinsel ));
803- DESCR ("does not matchregular expression , case-sensitive" );
803+ DESCR ("does not matchregex. , case-sensitive" );
804804DATA (insert OID = 1057 ("<>" PGUID 0 b t f 1042 1042 16 1057 1054 0 0 bpcharne neqsel neqjoinsel ));
805805DESCR ("not equal" );
806806DATA (insert OID = 1058 ("<" PGUID 0 b t f 1042 1042 16 1060 1061 0 0 bpcharlt intltsel intltjoinsel ));
@@ -815,9 +815,9 @@ DESCR("greater-than-or-equals");
815815DATA (insert OID = 1062 ("=" PGUID 0 b t t 1043 1043 16 1062 1065 1066 1066 varchareq eqsel eqjoinsel ));
816816DESCR ("equals" );
817817DATA (insert OID = 1063 ("~" PGUID 0 b t f 1043 25 16 0 1064 0 0 textregexeq eqsel eqjoinsel ));
818- DESCR ("matchesregular expression , case-sensitive" );
818+ DESCR ("matchesregex. , case-sensitive" );
819819DATA (insert OID = 1064 ("!~" PGUID 0 b t f 1043 25 16 0 1063 0 0 textregexne neqsel neqjoinsel ));
820- DESCR ("does not matchregular expression , case-sensitive" );
820+ DESCR ("does not matchregex. , case-sensitive" );
821821DATA (insert OID = 1065 ("<>" PGUID 0 b t f 1043 1043 16 1065 1062 0 0 varcharne neqsel neqjoinsel ));
822822DESCR ("not equal" );
823823DATA (insert OID = 1066 ("<" PGUID 0 b t f 1043 1043 16 1068 1069 0 0 varcharlt intltsel intltjoinsel ));
@@ -988,37 +988,37 @@ DESCR("does not match LIKE expression");
988988
989989/* case-insensitive LIKE hacks */
990990DATA (insert OID = 1220 ("~*" PGUID 0 b t f 409 25 16 0 1221 0 0 char2icregexeq eqsel eqjoinsel ));
991- DESCR ("matchesregular expression , case-insensitive" );
991+ DESCR ("matchesregex. , case-insensitive" );
992992DATA (insert OID = 1221 ("!~*" PGUID 0 b t f 409 25 16 0 1220 0 0 char2icregexne neqsel neqjoinsel ));
993- DESCR ("does not matchregular expression , case-insensitive" );
993+ DESCR ("does not matchregex. , case-insensitive" );
994994DATA (insert OID = 1222 ("~*" PGUID 0 b t f 410 25 16 0 1223 0 0 char4icregexeq eqsel eqjoinsel ));
995- DESCR ("matchesregular expression , case-insensitive" );
995+ DESCR ("matchesregex. , case-insensitive" );
996996DATA (insert OID = 1223 ("!~*" PGUID 0 b t f 410 25 16 0 1222 0 0 char4icregexne neqsel neqjoinsel ));
997- DESCR ("does not matchregular expression , case-insensitive" );
997+ DESCR ("does not matchregex. , case-insensitive" );
998998DATA (insert OID = 1224 ("~*" PGUID 0 b t f 411 25 16 0 1225 0 0 char8icregexeq eqsel eqjoinsel ));
999- DESCR ("matchesregular expression , case-insensitive" );
999+ DESCR ("matchesregex. , case-insensitive" );
10001000DATA (insert OID = 1225 ("!~*" PGUID 0 b t f 411 25 16 0 1224 0 0 char8icregexne neqsel neqjoinsel ));
1001- DESCR ("does not matchregular expression , case-insensitive" );
1001+ DESCR ("does not matchregex. , case-insensitive" );
10021002DATA (insert OID = 1226 ("~*" PGUID 0 b t f 19 25 16 0 1227 0 0 nameicregexeq eqsel eqjoinsel ));
1003- DESCR ("matchesregular expression , case-insensitive" );
1003+ DESCR ("matchesregex. , case-insensitive" );
10041004DATA (insert OID = 1227 ("!~*" PGUID 0 b t f 19 25 16 0 1226 0 0 nameicregexne neqsel neqjoinsel ));
1005- DESCR ("does not matchregular expression , case-insensitive" );
1005+ DESCR ("does not matchregex. , case-insensitive" );
10061006DATA (insert OID = 1228 ("~*" PGUID 0 b t f 25 25 16 0 1229 0 0 texticregexeq eqsel eqjoinsel ));
1007- DESCR ("matchesregular expression , case-insensitive" );
1007+ DESCR ("matchesregex. , case-insensitive" );
10081008DATA (insert OID = 1229 ("!~*" PGUID 0 b t f 25 25 16 0 1228 0 0 texticregexne eqsel eqjoinsel ));
1009- DESCR ("does not matchregular expression , case-insensitive" );
1009+ DESCR ("does not matchregex. , case-insensitive" );
10101010DATA (insert OID = 1230 ("~*" PGUID 0 b t f 20 25 16 0 1231 0 0 char16icregexeq eqsel eqjoinsel ));
1011- DESCR ("matchesregular expression , case-insensitive" );
1011+ DESCR ("matchesregex. , case-insensitive" );
10121012DATA (insert OID = 1231 ("!~*" PGUID 0 b t f 20 25 16 0 1230 0 0 char16icregexne neqsel neqjoinsel ));
1013- DESCR ("does not matchregular expression , case-insensitive" );
1013+ DESCR ("does not matchregex. , case-insensitive" );
10141014DATA (insert OID = 1232 ("~*" PGUID 0 b t f 1043 25 16 0 1233 0 0 texticregexeq eqsel eqjoinsel ));
1015- DESCR ("matchesregular expression , case-insensitive" );
1015+ DESCR ("matchesregex. , case-insensitive" );
10161016DATA (insert OID = 1233 ("!~*" PGUID 0 b t f 1043 25 16 0 1232 0 0 texticregexne neqsel neqjoinsel ));
1017- DESCR ("does not matchregular expression , case-insensitive" );
1017+ DESCR ("does not matchregex. , case-insensitive" );
10181018DATA (insert OID = 1234 ("~*" PGUID 0 b t f 1042 25 16 0 1235 0 0 texticregexeq eqsel eqjoinsel ));
1019- DESCR ("matchesregular expression , case-insensitive" );
1019+ DESCR ("matchesregex. , case-insensitive" );
10201020DATA (insert OID = 1235 ("!~*" PGUID 0 b t f 1042 25 16 0 1234 0 0 texticregexne neqsel neqjoinsel ));
1021- DESCR ("does not matchregular expression , case-insensitive" );
1021+ DESCR ("does not matchregex. , case-insensitive" );
10221022
10231023DATA (insert OID = 1300 ("=" PGUID 0 b t t 1296 1296 16 1300 1301 1302 1302 timestampeq eqsel eqjoinsel ));
10241024DESCR ("equals" );