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

Commitd905057

Browse files
committed
The timezone() family of functions (a/k/a AT TIME ZONE construct) can
safely be marked immutable, since their results don't depend on theTimeZone GUC variable. Per recent discussion.
1 parent2b55612 commitd905057

File tree

1 file changed

+6
-6
lines changed

1 file changed

+6
-6
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.327 2004/05/02 13:38:27 momjian Exp $
10+
* $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.328 2004/05/07 16:57:16 tgl Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -1315,7 +1315,7 @@ DESCR("convert timetz to text");
13151315

13161316
/* OIDS 1000 - 1999 */
13171317

1318-
DATA(insertOID=1026 (timezonePGNSPPGUID12fftfs21114"1186 1184"_null_timestamptz_izone-_null_ ));
1318+
DATA(insertOID=1026 (timezonePGNSPPGUID12fftfi21114"1186 1184"_null_timestamptz_izone-_null_ ));
13191319
DESCR("adjust timestamp to new time zone");
13201320

13211321
DATA(insertOID=1029 (nullvaluePGNSPPGUID12ffffi116"2276"_null_nullvalue-_null_ ));
@@ -1437,7 +1437,7 @@ DATA(insert OID = 1156 ( timestamptz_ge PGNSP PGUID 12 f f t f i 2 16 "1184 1
14371437
DESCR("greater-than-or-equal");
14381438
DATA(insertOID=1157 (timestamptz_gtPGNSPPGUID12fftfi216"1184 1184"_null_timestamp_gt-_null_ ));
14391439
DESCR("greater-than");
1440-
DATA(insertOID=1159 (timezonePGNSPPGUID12fftfs21114"25 1184"_null_timestamptz_zone-_null_ ));
1440+
DATA(insertOID=1159 (timezonePGNSPPGUID12fftfi21114"25 1184"_null_timestamptz_zone-_null_ ));
14411441
DESCR("adjust timestamp to new time zone");
14421442

14431443
DATA(insertOID=1160 (interval_inPGNSPPGUID12fftfs31186"2275 26 23"_null_interval_in-_null_ ));
@@ -2891,7 +2891,7 @@ DATA(insert OID = 2035 ( timestamp_smaller PGNSP PGUID 12 f f t f i 2 1114 "111
28912891
DESCR("smaller of two");
28922892
DATA(insertOID=2036 (timestamp_largerPGNSPPGUID12fftfi21114"1114 1114"_null_timestamp_larger-_null_ ));
28932893
DESCR("larger of two");
2894-
DATA(insertOID=2037 (timezonePGNSPPGUID12fftfs21266"25 1266"_null_timetz_zone-_null_ ));
2894+
DATA(insertOID=2037 (timezonePGNSPPGUID12fftfi21266"25 1266"_null_timetz_zone-_null_ ));
28952895
DESCR("adjust time with time zone to new zone");
28962896
DATA(insertOID=2038 (timezonePGNSPPGUID12fftfi21266"1186 1266"_null_timetz_izone-_null_ ));
28972897
DESCR("adjust time with time zone to new zone");
@@ -2934,9 +2934,9 @@ DESCR("date difference preserving months and years");
29342934
DATA(insertOID=2059 (agePGNSPPGUID14fftfs11186"1114"_null_"select pg_catalog.age(cast(current_date as timestamp without time zone), $1)"-_null_ ));
29352935
DESCR("date difference from today preserving months and years");
29362936

2937-
DATA(insertOID=2069 (timezonePGNSPPGUID12fftfs21184"25 1114"_null_timestamp_zone-_null_ ));
2937+
DATA(insertOID=2069 (timezonePGNSPPGUID12fftfi21184"25 1114"_null_timestamp_zone-_null_ ));
29382938
DESCR("adjust timestamp to new time zone");
2939-
DATA(insertOID=2070 (timezonePGNSPPGUID12fftfs21184"1186 1114"_null_timestamp_izone-_null_ ));
2939+
DATA(insertOID=2070 (timezonePGNSPPGUID12fftfi21184"1186 1114"_null_timestamp_izone-_null_ ));
29402940
DESCR("adjust timestamp to new time zone");
29412941
DATA(insertOID=2071 (date_pl_intervalPGNSPPGUID12fftfi21114"1082 1186"_null_date_pl_interval-_null_ ));
29422942
DESCR("add");

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp