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

Commit6435364

Browse files
committed
Mark to_char(timestamp without timezone) as stable, not immutable, since its
result now depends on the lc_messages setting, as noted by Bruce.Also, mark to_number() and the numeric-type variants of to_char() as stable,because their results depend on lc_numeric; this is a longstanding oversight.Also, mark to_date() and to_char(interval) as stable; although these appearnot to depend on any GUC variables as of CVS HEAD, that seems a propertyunlikely to survive future improvements. It seems best to mark all theformatting functions stable and be done with it.catversion not bumped, because this does not seem critical enough to forcea post-RC1 initdb, and anyway we cannot do so in the back branches.
1 parenta75ccd1 commit6435364

File tree

1 file changed

+10
-10
lines changed

1 file changed

+10
-10
lines changed

‎src/include/catalog/pg_proc.h‎

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2006, 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.428 2006/11/24 21:18:42 tgl Exp $
10+
* $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.429 2006/11/28 19:18:44 tgl Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -2614,23 +2614,23 @@ DESCR("(internal)");
26142614
/* formatting */
26152615
DATA(insertOID=1770 (to_charPGNSPPGUID12fftfs225"1184 25"_null__null__null_timestamptz_to_char-_null_ ));
26162616
DESCR("format timestamp with time zone to text");
2617-
DATA(insertOID=1772 (to_charPGNSPPGUID12fftfi225"1700 25"_null__null__null_numeric_to_char-_null_ ));
2617+
DATA(insertOID=1772 (to_charPGNSPPGUID12fftfs225"1700 25"_null__null__null_numeric_to_char-_null_ ));
26182618
DESCR("format numeric to text");
2619-
DATA(insertOID=1773 (to_charPGNSPPGUID12fftfi225"23 25"_null__null__null_int4_to_char-_null_ ));
2619+
DATA(insertOID=1773 (to_charPGNSPPGUID12fftfs225"23 25"_null__null__null_int4_to_char-_null_ ));
26202620
DESCR("format int4 to text");
2621-
DATA(insertOID=1774 (to_charPGNSPPGUID12fftfi225"20 25"_null__null__null_int8_to_char-_null_ ));
2621+
DATA(insertOID=1774 (to_charPGNSPPGUID12fftfs225"20 25"_null__null__null_int8_to_char-_null_ ));
26222622
DESCR("format int8 to text");
2623-
DATA(insertOID=1775 (to_charPGNSPPGUID12fftfi225"700 25"_null__null__null_float4_to_char-_null_ ));
2623+
DATA(insertOID=1775 (to_charPGNSPPGUID12fftfs225"700 25"_null__null__null_float4_to_char-_null_ ));
26242624
DESCR("format float4 to text");
2625-
DATA(insertOID=1776 (to_charPGNSPPGUID12fftfi225"701 25"_null__null__null_float8_to_char-_null_ ));
2625+
DATA(insertOID=1776 (to_charPGNSPPGUID12fftfs225"701 25"_null__null__null_float8_to_char-_null_ ));
26262626
DESCR("format float8 to text");
2627-
DATA(insertOID=1777 (to_numberPGNSPPGUID12fftfi21700"25 25"_null__null__null_numeric_to_number-_null_ ));
2627+
DATA(insertOID=1777 (to_numberPGNSPPGUID12fftfs21700"25 25"_null__null__null_numeric_to_number-_null_ ));
26282628
DESCR("convert text to numeric");
26292629
DATA(insertOID=1778 (to_timestampPGNSPPGUID12fftfs21184"25 25"_null__null__null_to_timestamp-_null_ ));
26302630
DESCR("convert text to timestamp with time zone");
2631-
DATA(insertOID=1780 (to_datePGNSPPGUID12fftfi21082"25 25"_null__null__null_to_date-_null_ ));
2631+
DATA(insertOID=1780 (to_datePGNSPPGUID12fftfs21082"25 25"_null__null__null_to_date-_null_ ));
26322632
DESCR("convert text to date");
2633-
DATA(insertOID=1768 (to_charPGNSPPGUID12fftfi225"1186 25"_null__null__null_interval_to_char-_null_ ));
2633+
DATA(insertOID=1768 (to_charPGNSPPGUID12fftfs225"1186 25"_null__null__null_interval_to_char-_null_ ));
26342634
DESCR("format interval to text");
26352635

26362636
DATA(insertOID=1282 (quote_identPGNSPPGUID12fftfi125"25"_null__null__null_quote_ident-_null_ ));
@@ -3035,7 +3035,7 @@ DATA(insert OID = 2047 ( timetzPGNSP PGUID 12 f f t f s 1 1266 "1083" _null_
30353035
DESCR("convert time to timetz");
30363036
DATA(insertOID=2048 (isfinitePGNSPPGUID12fftfi116"1114"_null__null__null_timestamp_finite-_null_ ));
30373037
DESCR("finite timestamp?");
3038-
DATA(insertOID=2049 (to_charPGNSPPGUID12fftfi225"1114 25"_null__null__null_timestamp_to_char-_null_ ));
3038+
DATA(insertOID=2049 (to_charPGNSPPGUID12fftfs225"1114 25"_null__null__null_timestamp_to_char-_null_ ));
30393039
DESCR("format timestamp to text");
30403040
DATA(insertOID=2052 (timestamp_eqPGNSPPGUID12fftfi216"1114 1114"_null__null__null_timestamp_eq-_null_ ));
30413041
DESCR("equal");

0 commit comments

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