Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit354a18f

Browse files
author
Thomas G. Lockhart
committed
Add tinterval comparison operators.
Add integer/money arithmetic.
1 parentaae2420 commit354a18f

File tree

2 files changed

+47
-8
lines changed

2 files changed

+47
-8
lines changed

‎src/include/catalog/pg_operator.h

Lines changed: 22 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_operator.h,v 1.15 1997/09/08 02:35:20 momjian Exp $
10+
* $Id: pg_operator.h,v 1.16 1997/09/20 16:29:36 thomas Exp $
1111
*
1212
* NOTES
1313
* the genbki.sh script reads this file and generates .bki
@@ -244,7 +244,7 @@ DATA(insert OID = 568 ( "<" PGUID 0 b t f 703 703 16 569 571 0 0 reltimelt
244244
DATA(insertOID=569 (">"PGUID0btf7037031656857000reltimegt-- ));
245245
DATA(insertOID=570 ("<="PGUID0btf7037031657156900reltimele-- ));
246246
DATA(insertOID=571 (">="PGUID0btf7037031657056800reltimege-- ));
247-
DATA(insertOID=572 ("="PGUID0btt70470416572000intervaleq-- ));
247+
DATA(insertOID=572 ("~="PGUID0btt70470416572000intervalsame-- ));
248248
DATA(insertOID=573 ("<<"PGUID0btf704704160000intervalct-- ));
249249
DATA(insertOID=574 ("&&"PGUID0btf704704160000intervalov-- ));
250250
DATA(insertOID=575 ("#="PGUID0btf7047031605760568intervalleneq-- ));
@@ -399,6 +399,13 @@ DATA(insert OID = 807 ( "/" PGUID 0 b t f 603 600603 0 0 0 0 box_div
399399
DATA(insertOID=808 ("?-"PGUID0btf60060016808000point_horiz-- ));
400400
DATA(insertOID=809 ("?|"PGUID0btf60060016809000point_vert-- ));
401401

402+
DATA(insertOID=811 ("="PGUID0btt70470416811000intervaleq-- ));
403+
DATA(insertOID=812 ("<>"PGUID0btt70470416812000intervalne-- ));
404+
DATA(insertOID=813 ("<"PGUID0btt70470416813000intervallt-- ));
405+
DATA(insertOID=814 (">"PGUID0btt70470416814000intervalgt-- ));
406+
DATA(insertOID=815 ("<="PGUID0btt70470416815000intervalle-- ));
407+
DATA(insertOID=816 (">="PGUID0btt70470416816000intervalge-- ));
408+
402409
DATA(insertOID=830 ("<"PGUID0btf8108101683483300oidint2ltintltselintltjoinsel ));
403410
DATA(insertOID=831 ("<="PGUID0btf8108101683383400oidint2leintltselintltjoinsel ));
404411
DATA(insertOID=832 ("="PGUID0btf8108101683283500oidint2eqintltselintltjoinsel ));
@@ -419,8 +426,19 @@ DATA(insert OID = 904 ( "<=" PGUID 0 b t f 790 79016 905 9030 0 cash_le
419426
DATA(insertOID=905 (">="PGUID0btf7907901690490200cash_geintgtselintgtjoinsel ));
420427
DATA(insertOID=906 ("+"PGUID0btf790790790906000cash_pl-- ));
421428
DATA(insertOID=907 ("-"PGUID0btf7907907900000cash_mi-- ));
422-
DATA(insertOID=908 ("*"PGUID0btf790701790909000cash_mul-- ));
423-
DATA(insertOID=909 ("/"PGUID0btf7907017900000cash_div-- ));
429+
DATA(insertOID=908 ("*"PGUID0btf790701790916000cash_mul_flt8-- ));
430+
DATA(insertOID=909 ("/"PGUID0btf7907017900000cash_div_flt8-- ));
431+
DATA(insertOID=912 ("*"PGUID0btf79023790917000cash_mul_int4-- ));
432+
DATA(insertOID=913 ("/"PGUID0btf790237900000cash_div_int4-- ));
433+
DATA(insertOID=914 ("*"PGUID0btf79021790918000cash_mul_int2-- ));
434+
DATA(insertOID=915 ("/"PGUID0btf790217900000cash_div_int2-- ));
435+
DATA(insertOID=916 ("*"PGUID0btf701790790908000flt8_mul_cash-- ));
436+
DATA(insertOID=917 ("*"PGUID0btf23790790912000int4_mul_cash-- ));
437+
DATA(insertOID=918 ("*"PGUID0btf21790790914000int2_mul_cash-- ));
438+
439+
DATA(insertOID=950 ("*"PGUID0btf790700790988000cash_mul_flt4-- ));
440+
DATA(insertOID=951 ("/"PGUID0btf7907007900000cash_div_flt4-- ));
441+
DATA(insertOID=988 ("*"PGUID0btf700790790950000flt4_mul_cash-- ));
424442

425443
DATA(insertOID=930 ("<"PGUID0btf9109101693493300oidint4ltintltselintltjoinsel ));
426444
DATA(insertOID=931 ("<="PGUID0btf9109101693393400oidint4leintltselintltjoinsel ));

‎src/include/catalog/pg_proc.h

Lines changed: 25 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
*
77
* Copyright (c) 1994, Regents of the University of California
88
*
9-
* $Id: pg_proc.h,v 1.30 1997/09/08 21:51:29 momjian Exp $
9+
* $Id: pg_proc.h,v 1.31 1997/09/20 16:29:38 thomas Exp $
1010
*
1111
* NOTES
1212
* The script catalog/genbki.sh reads this file and generates .bki
@@ -341,7 +341,7 @@ DATA(insert OID = 259 ( reltimelt PGUID 11 f t f 2 f 16 "703 703" 100 0 0 1
341341
DATA(insertOID=260 (reltimegtPGUID11ftf2f16"703 703"10000100foobar ));
342342
DATA(insertOID=261 (reltimelePGUID11ftf2f16"703 703"10000100foobar ));
343343
DATA(insertOID=262 (reltimegePGUID11ftf2f16"703 703"10000100foobar ));
344-
DATA(insertOID=263 (intervaleqPGUID11ftf2f16"704 704"10000100foobar ));
344+
DATA(insertOID=263 (intervalsamePGUID11ftf2f16"704 704"10000100foobar ));
345345
DATA(insertOID=264 (intervalctPGUID11ftf2f16"704 704"10000100foobar ));
346346
DATA(insertOID=265 (intervalovPGUID11ftf2f16"704 704"10000100foobar ));
347347
DATA(insertOID=266 (intervalleneqPGUID11ftf2f16"704 703"10000100foobar ));
@@ -616,6 +616,13 @@ DATA(insert OID = 780 ( gistmarkpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 f
616616
DATA(insertOID=781 (gistrestrposPGUID11ftf1f23"0"10000100foobar ));
617617
DATA(insertOID=782 (gistbuildPGUID11ftf9f23"0"10000100foobar ));
618618

619+
DATA(insertOID=784 (intervaleqPGUID11ftf2f16"704 704"10000100foobar ));
620+
DATA(insertOID=785 (intervalnePGUID11ftf2f16"704 704"10000100foobar ));
621+
DATA(insertOID=786 (intervalltPGUID11ftf2f16"704 704"10000100foobar ));
622+
DATA(insertOID=787 (intervalgtPGUID11ftf2f16"704 704"10000100foobar ));
623+
DATA(insertOID=788 (intervallePGUID11ftf2f16"704 704"10000100foobar ));
624+
DATA(insertOID=789 (intervalgePGUID11ftf2f16"704 704"10000100foobar ));
625+
619626
/* OIDS 800 - 899 */
620627

621628
DATA(insertOID=820 (oidint2inPGUID11ftf1f810"0"10000100foobar));
@@ -650,6 +657,17 @@ DATA(insert OID = 859 ( namenlike PGUID 11 f t f 2 f 16 "19 25" 100 0 0 10
650657
DATA(insertOID=860 (char16likePGUID11ftf2f16"20 25"10000100foobar ));
651658
DATA(insertOID=861 (char16nlikePGUID11ftf2f16"20 25"10000100foobar ));
652659

660+
DATA(insertOID=846 (cash_mul_flt4PGUID11ftf2f790"790 700"10000100foobar ));
661+
DATA(insertOID=847 (cash_div_flt4PGUID11ftf2f790"790 700"10000100foobar ));
662+
DATA(insertOID=848 (flt4_mul_cashPGUID11ftf2f790"700 790"10000100foobar ));
663+
664+
DATA(insertOID=862 (int4_mul_cashPGUID11ftf2f790"23 790"10000100foobar ));
665+
DATA(insertOID=863 (int2_mul_cashPGUID11ftf2f790"21 790"10000100foobar ));
666+
DATA(insertOID=864 (cash_mul_int4PGUID11ftf2f790"790 23"10000100foobar ));
667+
DATA(insertOID=865 (cash_div_int4PGUID11ftf2f790"790 23"10000100foobar ));
668+
DATA(insertOID=866 (cash_mul_int2PGUID11ftf2f790"790 21"10000100foobar ));
669+
DATA(insertOID=867 (cash_div_int2PGUID11ftf2f790"790 21"10000100foobar ));
670+
653671
DATA(insertOID=886 (cash_inPGUID11ftf1f790"0"10000100foobar ));
654672
DATA(insertOID=887 (cash_outPGUID11ftf1f23"0"10000100foobar ));
655673
DATA(insertOID=888 (cash_eqPGUID11ftf2f16"790 790"10000100foobar ));
@@ -660,11 +678,13 @@ DATA(insert OID = 892 ( cash_gt PGUID 11 f t f 2 f 16 "790 790" 100 0 0 1
660678
DATA(insertOID=893 (cash_gePGUID11ftf2f16"790 790"10000100foobar ));
661679
DATA(insertOID=894 (cash_plPGUID11ftf2f790"790 790"10000100foobar ));
662680
DATA(insertOID=895 (cash_miPGUID11ftf2f790"790 790"10000100foobar ));
663-
DATA(insertOID=896 (cash_mulPGUID11ftf2f790"790 701"10000100foobar ));
664-
DATA(insertOID=897 (cash_divPGUID11ftf2f790"790 701"10000100foobar ));
681+
DATA(insertOID=896 (cash_mul_flt8PGUID11ftf2f790"790 701"10000100foobar ));
682+
DATA(insertOID=897 (cash_div_flt8PGUID11ftf2f790"790 701"10000100foobar ));
665683
DATA(insertOID=898 (cashlargerPGUID11ftf2f790"790 790"10000100foobar ));
666684
DATA(insertOID=899 (cashsmallerPGUID11ftf2f790"790 790"10000100foobar ));
667685

686+
DATA(insertOID=919 (flt8_mul_cashPGUID11ftf2f790"701 790"10000100foobar ));
687+
668688
/* OIDS 900 - 999 */
669689
DATA(insertOID=920 (oidint4inPGUID11ftf1f910"0"10000100foobar));
670690
DATA(insertOID=921 (oidint4outPGUID11ftf1f19"0"10000100foobar));
@@ -730,6 +750,7 @@ DATA(insert OID = 984 ( path_n_eq PGUID 11 f t f 2 f 16 "602 602" 100 0 0 1
730750
DATA(insertOID=985 (path_n_lePGUID11ftf2f16"602 602"10000100foobar ));
731751
DATA(insertOID=986 (path_n_gePGUID11ftf2f16"602 602"10000100foobar ));
732752
DATA(insertOID=987 (path_lengthPGUID11ftf1f701"602"100010foobar ));
753+
DATA(insertOID=988 (point_nePGUID11ftf2f16"600 600"10000100foobar ));
733754
DATA(insertOID=989 (point_vertPGUID11ftf2f16"600 600"10000100foobar ));
734755
DATA(insertOID=990 (point_horizPGUID11ftf2f16"600 600"10000100foobar ));
735756
DATA(insertOID=991 (point_distancePGUID11ftf2f701"600 600"10000100foobar ));

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp