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

Commit2b7ccb1

Browse files
committed
Some further kibitzing on cachability of datetime functions.
In particular, mark all I/O functions that can produce or consumea date as noncachable, in light of existence of DateStyle variable.
1 parent4a147ba commit2b7ccb1

File tree

2 files changed

+46
-46
lines changed

2 files changed

+46
-46
lines changed

‎src/include/catalog/catversion.h‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@
3737
* Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
3838
* Portions Copyright (c) 1994, Regents of the University of California
3939
*
40-
* $Id: catversion.h,v 1.97 2001/10/0305:29:24 thomas Exp $
40+
* $Id: catversion.h,v 1.98 2001/10/0317:22:05 tgl Exp $
4141
*
4242
*-------------------------------------------------------------------------
4343
*/
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO200110011
56+
#defineCATALOG_VERSION_NO200110031
5757

5858
#endif

‎src/include/catalog/pg_proc.h‎

Lines changed: 44 additions & 44 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_proc.h,v 1.214 2001/10/0305:29:24 thomas Exp $
10+
* $Id: pg_proc.h,v 1.215 2001/10/0317:22:05 tgl Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -509,23 +509,23 @@ DATA(insert OID = 246 ( tintervalin PGUID 12 f t f t 1 f 704 "0" 100 0 0 100
509509
DESCR("(internal)");
510510
DATA(insertOID=247 (tintervaloutPGUID12ftft1f23"0"10000100tintervalout- ));
511511
DESCR("(internal)");
512-
DATA(insertOID=248 (intintervalPGUID12ftft2f16"702 704"10000100intinterval- ));
512+
DATA(insertOID=248 (intintervalPGUID12fttt2f16"702 704"10000100intinterval- ));
513513
DESCR("abstime in tinterval");
514-
DATA(insertOID=249 (tintervalrelPGUID12ftft1f703"704"10000100tintervalrel- ));
514+
DATA(insertOID=249 (tintervalrelPGUID12fttt1f703"704"10000100tintervalrel- ));
515515
DESCR("");
516516
DATA(insertOID=250 (timenowPGUID12ftft0f702"0"10000100timenow- ));
517517
DESCR("Current date and time (abstime)");
518-
DATA(insertOID=251 (abstimeeqPGUID12ftft2f16"702 702"10000100abstimeeq- ));
518+
DATA(insertOID=251 (abstimeeqPGUID12fttt2f16"702 702"10000100abstimeeq- ));
519519
DESCR("equal");
520-
DATA(insertOID=252 (abstimenePGUID12ftft2f16"702 702"10000100abstimene- ));
520+
DATA(insertOID=252 (abstimenePGUID12fttt2f16"702 702"10000100abstimene- ));
521521
DESCR("not equal");
522-
DATA(insertOID=253 (abstimeltPGUID12ftft2f16"702 702"10000100abstimelt- ));
522+
DATA(insertOID=253 (abstimeltPGUID12fttt2f16"702 702"10000100abstimelt- ));
523523
DESCR("less-than");
524-
DATA(insertOID=254 (abstimegtPGUID12ftft2f16"702 702"10000100abstimegt- ));
524+
DATA(insertOID=254 (abstimegtPGUID12fttt2f16"702 702"10000100abstimegt- ));
525525
DESCR("greater-than");
526-
DATA(insertOID=255 (abstimelePGUID12ftft2f16"702 702"10000100abstimele- ));
526+
DATA(insertOID=255 (abstimelePGUID12fttt2f16"702 702"10000100abstimele- ));
527527
DESCR("less-than-or-equal");
528-
DATA(insertOID=256 (abstimegePGUID12ftft2f16"702 702"10000100abstimege- ));
528+
DATA(insertOID=256 (abstimegePGUID12fttt2f16"702 702"10000100abstimege- ));
529529
DESCR("greater-than-or-equal");
530530
DATA(insertOID=257 (reltimeeqPGUID12fttt2f16"703 703"10000100reltimeeq- ));
531531
DESCR("equal");
@@ -539,31 +539,31 @@ DATA(insert OID = 261 ( reltimele PGUID 12 f t t t 2 f 16 "703 703" 100 0 0
539539
DESCR("less-than-or-equal");
540540
DATA(insertOID=262 (reltimegePGUID12fttt2f16"703 703"10000100reltimege- ));
541541
DESCR("greater-than-or-equal");
542-
DATA(insertOID=263 (tintervalsamePGUID12ftft2f16"704 704"10000100tintervalsame- ));
542+
DATA(insertOID=263 (tintervalsamePGUID12fttt2f16"704 704"10000100tintervalsame- ));
543543
DESCR("same as");
544-
DATA(insertOID=264 (tintervalctPGUID12ftft2f16"704 704"10000100tintervalct- ));
544+
DATA(insertOID=264 (tintervalctPGUID12fttt2f16"704 704"10000100tintervalct- ));
545545
DESCR("less-than");
546-
DATA(insertOID=265 (tintervalovPGUID12ftft2f16"704 704"10000100tintervalov- ));
546+
DATA(insertOID=265 (tintervalovPGUID12fttt2f16"704 704"10000100tintervalov- ));
547547
DESCR("overlaps");
548-
DATA(insertOID=266 (tintervalleneqPGUID12ftft2f16"704 703"10000100tintervalleneq- ));
548+
DATA(insertOID=266 (tintervalleneqPGUID12fttt2f16"704 703"10000100tintervalleneq- ));
549549
DESCR("length equal");
550-
DATA(insertOID=267 (tintervallennePGUID12ftft2f16"704 703"10000100tintervallenne- ));
550+
DATA(insertOID=267 (tintervallennePGUID12fttt2f16"704 703"10000100tintervallenne- ));
551551
DESCR("length not equal to");
552-
DATA(insertOID=268 (tintervallenltPGUID12ftft2f16"704 703"10000100tintervallenlt- ));
552+
DATA(insertOID=268 (tintervallenltPGUID12fttt2f16"704 703"10000100tintervallenlt- ));
553553
DESCR("length less-than");
554-
DATA(insertOID=269 (tintervallengtPGUID12ftft2f16"704 703"10000100tintervallengt- ));
554+
DATA(insertOID=269 (tintervallengtPGUID12fttt2f16"704 703"10000100tintervallengt- ));
555555
DESCR("length greater-than");
556-
DATA(insertOID=270 (tintervallenlePGUID12ftft2f16"704 703"10000100tintervallenle- ));
556+
DATA(insertOID=270 (tintervallenlePGUID12fttt2f16"704 703"10000100tintervallenle- ));
557557
DESCR("length less-than-or-equal");
558-
DATA(insertOID=271 (tintervallengePGUID12ftft2f16"704 703"10000100tintervallenge- ));
558+
DATA(insertOID=271 (tintervallengePGUID12fttt2f16"704 703"10000100tintervallenge- ));
559559
DESCR("length greater-than-or-equal");
560-
DATA(insertOID=272 (tintervalstartPGUID12ftft1f702"704"10000100tintervalstart- ));
560+
DATA(insertOID=272 (tintervalstartPGUID12fttt1f702"704"10000100tintervalstart- ));
561561
DESCR("start of interval");
562-
DATA(insertOID=273 (tintervalendPGUID12ftft1f702"704"10000100tintervalend- ));
562+
DATA(insertOID=273 (tintervalendPGUID12fttt1f702"704"10000100tintervalend- ));
563563
DESCR("");
564564
DATA(insertOID=274 (timeofdayPGUID12ftft0f25"0"10000100timeofday- ));
565565
DESCR("Current date and time with microseconds");
566-
DATA(insertOID=275 (isfinitePGUID12ftft1f16"702"10000100abstime_finite- ));
566+
DATA(insertOID=275 (isfinitePGUID12fttt1f16"702"10000100abstime_finite- ));
567567
DESCR("");
568568

569569
DATA(insertOID=276 (int2facPGUID12fttt1f23"21"10000100int2fac- ));
@@ -741,7 +741,7 @@ DATA(insert OID = 356 ( btoidcmp PGUID 12 f t t t 2 f 23 "26 26" 100 0 0 10
741741
DESCR("btree less-equal-greater");
742742
DATA(insertOID=404 (btoidvectorcmpPGUID12fttt2f23"30 30"10000100btoidvectorcmp- ));
743743
DESCR("btree less-equal-greater");
744-
DATA(insertOID=357 (btabstimecmpPGUID12ftft2f23"702 702"10000100btabstimecmp- ));
744+
DATA(insertOID=357 (btabstimecmpPGUID12fttt2f23"702 702"10000100btabstimecmp- ));
745745
DESCR("btree less-equal-greater");
746746
DATA(insertOID=358 (btcharcmpPGUID12fttt2f23"18 18"10000100btcharcmp- ));
747747
DESCR("btree less-equal-greater");
@@ -913,7 +913,7 @@ DESCR("adjust char() to typmod length");
913913
DATA(insertOID=669 (varcharPGUID12fttt2f1043"1043 23"10000100varchar- ));
914914
DESCR("adjust varchar() to typmod length");
915915

916-
DATA(insertOID=676 (mktintervalPGUID12ftft2f704"702 702"10000100mktinterval- ));
916+
DATA(insertOID=676 (mktintervalPGUID12fttt2f704"702 702"10000100mktinterval- ));
917917
DESCR("convert to tinterval");
918918
DATA(insertOID=619 (oidvectornePGUID12fttt2f16"30 30"10000100oidvectorne- ));
919919
DESCR("not equal");
@@ -992,9 +992,9 @@ DATA(insert OID = 760 ( smgrin PGUID 12 f t f t 1 f 210 "0" 100 0 0 100 s
992992
DESCR("storage manager(internal)");
993993
DATA(insertOID=761 (smgroutPGUID12ftft1f23"0"10000100smgrout- ));
994994
DESCR("storage manager(internal)");
995-
DATA(insertOID=762 (smgreqPGUID12ftft2f16"210 210"10000100smgreq- ));
995+
DATA(insertOID=762 (smgreqPGUID12fttt2f16"210 210"10000100smgreq- ));
996996
DESCR("storage manager");
997-
DATA(insertOID=763 (smgrnePGUID12ftft2f16"210 210"10000100smgrne- ));
997+
DATA(insertOID=763 (smgrnePGUID12fttt2f16"210 210"10000100smgrne- ));
998998
DESCR("storage manager");
999999

10001000
DATA(insertOID=764 (lo_importPGUID12ftft1f26"25"10000100lo_import- ));
@@ -1034,17 +1034,17 @@ DESCR("gist(internal)");
10341034
DATA(insertOID=772 (gistcostestimatePGUID12ftft8f0"0 0 0 0 0 0 0 0"10000100gistcostestimate- ));
10351035
DESCR("gist(internal)");
10361036

1037-
DATA(insertOID=784 (tintervaleqPGUID12ftft2f16"704 704"10000100tintervaleq- ));
1037+
DATA(insertOID=784 (tintervaleqPGUID12fttt2f16"704 704"10000100tintervaleq- ));
10381038
DESCR("equal");
1039-
DATA(insertOID=785 (tintervalnePGUID12ftft2f16"704 704"10000100tintervalne- ));
1039+
DATA(insertOID=785 (tintervalnePGUID12fttt2f16"704 704"10000100tintervalne- ));
10401040
DESCR("not equal");
1041-
DATA(insertOID=786 (tintervalltPGUID12ftft2f16"704 704"10000100tintervallt- ));
1041+
DATA(insertOID=786 (tintervalltPGUID12fttt2f16"704 704"10000100tintervallt- ));
10421042
DESCR("less-than");
1043-
DATA(insertOID=787 (tintervalgtPGUID12ftft2f16"704 704"10000100tintervalgt- ));
1043+
DATA(insertOID=787 (tintervalgtPGUID12fttt2f16"704 704"10000100tintervalgt- ));
10441044
DESCR("greater-than");
1045-
DATA(insertOID=788 (tintervallePGUID12ftft2f16"704 704"10000100tintervalle- ));
1045+
DATA(insertOID=788 (tintervallePGUID12fttt2f16"704 704"10000100tintervalle- ));
10461046
DESCR("less-than-or-equal");
1047-
DATA(insertOID=789 (tintervalgePGUID12ftft2f16"704 704"10000100tintervalge- ));
1047+
DATA(insertOID=789 (tintervalgePGUID12fttt2f16"704 704"10000100tintervalge- ));
10481048
DESCR("greater-than-or-equal");
10491049

10501050
/* OIDS 800 - 899 */
@@ -1258,9 +1258,9 @@ DESCR("equal");
12581258

12591259
DATA(insertOID=748 (datePGUID12ftft1f1082"25"10000100text_date- ));
12601260
DESCR("convert text to date");
1261-
DATA(insertOID=749 (textPGUID12fttt1f25"1082"10000100date_text- ));
1261+
DATA(insertOID=749 (textPGUID12ftft1f25"1082"10000100date_text- ));
12621262
DESCR("convert date to text");
1263-
DATA(insertOID=837 (timePGUID12fttt1f1083"25"10000100text_time- ));
1263+
DATA(insertOID=837 (timePGUID12ftft1f1083"25"10000100text_time- ));
12641264
DESCR("convert text to time");
12651265
DATA(insertOID=948 (textPGUID12fttt1f25"1083"10000100time_text- ));
12661266
DESCR("convert time to text");
@@ -1332,7 +1332,7 @@ DATA(insert OID = 1081 ( format_type PGUID 12 f t t f 2 f 25 "26 23" 100 0 0
13321332
DESCR("format a type oid and atttypmod to canonical SQL");
13331333
DATA(insertOID=1084 (date_inPGUID12ftft1f1082"0"10000100date_in- ));
13341334
DESCR("(internal)");
1335-
DATA(insertOID=1085 (date_outPGUID12fttt1f23"0"10000100date_out- ));
1335+
DATA(insertOID=1085 (date_outPGUID12ftft1f23"0"10000100date_out- ));
13361336
DESCR("(internal)");
13371337
DATA(insertOID=1086 (date_eqPGUID12fttt2f16"1082 1082"10000100date_eq- ));
13381338
DESCR("equal");
@@ -1391,7 +1391,7 @@ DESCR("divide");
13911391

13921392
DATA(insertOID=1150 (timestamptz_inPGUID12ftft1f1184"0"10000100timestamptz_in- ));
13931393
DESCR("(internal)");
1394-
DATA(insertOID=1151 (timestamptz_outPGUID12fttt1f23"0"10000100timestamptz_out- ));
1394+
DATA(insertOID=1151 (timestamptz_outPGUID12ftft1f23"0"10000100timestamptz_out- ));
13951395
DESCR("(internal)");
13961396
DATA(insertOID=1152 (timestamptz_eqPGUID12fttt2f16"1184 1184"10000100timestamp_eq- ));
13971397
DESCR("equal");
@@ -1516,7 +1516,7 @@ DESCR("absolute value");
15161516
DATA(insertOID=1253 (int2absPGUID12fttt1f21"21"10000100int2abs- ));
15171517
DESCR("absolute value");
15181518

1519-
DATA(insertOID=1263 (intervalPGUID12fttt1f1186"25"10000100text_interval- ));
1519+
DATA(insertOID=1263 (intervalPGUID12ftft1f1186"25"10000100text_interval- ));
15201520
DESCR("convert text to interval");
15211521

15221522
DATA(insertOID=1271 (overlapsPGUID12fttf4f16"1266 1266 1266 1266"10000100overlaps_timetz- ));
@@ -1551,7 +1551,7 @@ DESCR("adjust char()[] to typmod length");
15511551
DATA(insertOID=1291 (_varcharPGUID12fttt2f1015"1015 23"10000100_varchar- ));
15521552
DESCR("adjust varchar()[] to typmod length");
15531553

1554-
DATA(insertOID=1292 (tideqPGUID12ftft2f16"27 27"10000100tideq- ));
1554+
DATA(insertOID=1292 (tideqPGUID12fttt2f16"27 27"10000100tideq- ));
15551555
DESCR("equal");
15561556
DATA(insertOID=1293 (currtidPGUID12ftft2f27"26 27"10000100currtid_byreloid- ));
15571557
DESCR("latest tid of a tuple");
@@ -1598,7 +1598,7 @@ DESCR("SQL92 interval comparison");
15981598

15991599
DATA(insertOID=1312 (timestamp_inPGUID12ftft1f1114"0"10000100timestamp_in- ));
16001600
DESCR("(internal)");
1601-
DATA(insertOID=1313 (timestamp_outPGUID12fttt1f23"0"10000100timestamp_out- ));
1601+
DATA(insertOID=1313 (timestamp_outPGUID12ftft1f23"0"10000100timestamp_out- ));
16021602
DESCR("(internal)");
16031603
DATA(insertOID=1314 (timestamptz_cmpPGUID12fttt2f23"1184 1184"10000100timestamp_cmp- ));
16041604
DESCR("less-equal-greater");
@@ -1671,7 +1671,7 @@ DATA(insert OID = 1362 ( time PGUID 14 f t t t 1 f 1083 "1083" 100 0 0 100
16711671
DESCR("convert (noop)");
16721672
DATA(insertOID=1364 (timePGUID14fttt1f1083"702"10000100"select time(cast($1 as timestamp without time zone))"- ));
16731673
DESCR("convert abstime to time");
1674-
DATA(insertOID=1365 (abstimePGUID14ftft1f702"702"10000100"select $1"- ));
1674+
DATA(insertOID=1365 (abstimePGUID14fttt1f702"702"10000100"select $1"- ));
16751675
DESCR("convert (noop)");
16761676
DATA(insertOID=1367 (reltimePGUID14fttt1f703"703"10000100"select $1"- ));
16771677
DESCR("convert (noop)");
@@ -1715,7 +1715,7 @@ DATA(insert OID = 1384 ( date_part PGUID 14 f t t t 2 f 701 "25 1082" 100 0
17151715
DESCR("extract field from date");
17161716
DATA(insertOID=1385 (date_partPGUID14fttt2f701"25 1083"10000100"select date_part($1, interval($2))"- ));
17171717
DESCR("extract field from time");
1718-
DATA(insertOID=1386 (agePGUID14fttt1f1186"1184"10000100"select age(\'today\', $1)"- ));
1718+
DATA(insertOID=1386 (agePGUID14ftft1f1186"1184"10000100"select age(cast(current_date as timestamp with time zone), $1)"- ));
17191719
DESCR("date difference from today preserving months and years");
17201720

17211721
DATA(insertOID=1387 (timetzPGUID14fttt1f1266"1266"10000100"select $1"- ));
@@ -1920,7 +1920,7 @@ DATA(insert OID = 1479 ( circlePGUID 12 f t t t 1 f 718 "603" 100 0 0 100 b
19201920
DESCR("convert box to circle");
19211921
DATA(insertOID=1480 (boxPGUID12fttt1f603"718"10000100circle_box- ));
19221922
DESCR("convert circle to box");
1923-
DATA(insertOID=1481 (tintervalPGUID12ftft2f704"702 702"10000100mktinterval- ));
1923+
DATA(insertOID=1481 (tintervalPGUID12fttt2f704"702 702"10000100mktinterval- ));
19241924
DESCR("convert to tinterval");
19251925

19261926
DATA(insertOID=1482 (lseg_nePGUID12fttt2f16"601 601"10000100lseg_ne- ));
@@ -2741,7 +2741,7 @@ DESCR("not equal");
27412741
DATA(insertOID=1954 (byteacmpPGUID12fttt2f23"17 17"10000100byteacmp- ));
27422742
DESCR("less-equal-greater");
27432743

2744-
DATA(insertOID=1961 (timestampPGUID12ftft2f1114"1114 23"10000100timestamp_scale- ));
2744+
DATA(insertOID=1961 (timestampPGUID12fttt2f1114"1114 23"10000100timestamp_scale- ));
27452745
DESCR("adjust time precision");
27462746

27472747
DATA(insertOID=1965 (oidlargerPGUID12fttt2f26"26 26"10000100oidlarger- ));
@@ -2807,7 +2807,7 @@ DATA(insert OID = 2032 ( timestamp_pl_span PGUID 12 f t t t 2 f 1114 "1114 1186
28072807
DESCR("plus");
28082808
DATA(insertOID=2033 (timestamp_mi_spanPGUID12fttt2f1114"1114 1186"10000100timestamp_mi_span- ));
28092809
DESCR("minus");
2810-
DATA(insertOID=2034 (textPGUID12fttt1f25"1114"10000100timestamp_text- ));
2810+
DATA(insertOID=2034 (textPGUID12ftft1f25"1114"10000100timestamp_text- ));
28112811
DESCR("convert timestamp to text");
28122812
DATA(insertOID=2035 (timestamp_smallerPGUID12fttt2f1114"1114 1114"10000100timestamp_smaller- ));
28132813
DESCR("smaller of two");
@@ -2853,7 +2853,7 @@ DATA(insert OID = 2057 ( timestamp_gtPGUID 12 f t t t 2 f 16 "1114 1114" 100
28532853
DESCR("greater-than");
28542854
DATA(insertOID=2058 (agePGUID12fttt2f1186"1114 1114"10000100timestamp_age- ));
28552855
DESCR("date difference preserving months and years");
2856-
DATA(insertOID=2059 (agePGUID14fttt1f1186"1114"10000100"select age(\'today\', $1)"- ));
2856+
DATA(insertOID=2059 (agePGUID14ftft1f1186"1114"10000100"select age(cast(current_date as timestamp without time zone), $1)"- ));
28572857
DESCR("date difference from today preserving months and years");
28582858
DATA(insertOID=2069 (timezonePGUID12ftft2f1184"25 1114"10000100timestamp_zone- ));
28592859
DESCR("time zone");

0 commit comments

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