diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-28 19:19:16 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-28 19:19:16 +0000 |
| commit | 8eb0f23a961e4c6e08191d8bf6c2a805d0c71eff (patch) | |
| tree | e86df107385fe3ae7fa0376a6e90e8bf1a21a5db | |
| parent | e53a43bf1710533028c4e57df5c0322281827779 (diff) | |
| download | postgresql-8eb0f23a961e4c6e08191d8bf6c2a805d0c71eff.tar.gz postgresql-8eb0f23a961e4c6e08191d8bf6c2a805d0c71eff.zip | |
Mark to_number() and the numeric-type variants of to_char() as stable, not
immutable, because their results depend on lc_numeric; this is a longstanding
oversight. We cannot force initdb for this in the back branches, but we can
at least provide correct catalog entries for future installations.
| -rw-r--r-- | src/include/catalog/pg_proc.h | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 4128d5f1643..0ef8a38656f 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.314 2003/10/21 16:23:16 tgl Exp $ + * $Id: pg_proc.h,v 1.314.2.1 2006/11/28 19:19:16 tgl Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -2545,17 +2545,17 @@ DESCR("(internal)"); /* formatting */ DATA(insert OID = 1770 ( to_char PGNSP PGUID 12 f f t f s 2 25 "1184 25" timestamptz_to_char - _null_ )); DESCR("format timestamp with time zone to text"); -DATA(insert OID = 1772 ( to_char PGNSP PGUID 12 f f t f i 2 25 "1700 25" numeric_to_char - _null_ )); +DATA(insert OID = 1772 ( to_char PGNSP PGUID 12 f f t f s 2 25 "1700 25" numeric_to_char - _null_ )); DESCR("format numeric to text"); -DATA(insert OID = 1773 ( to_char PGNSP PGUID 12 f f t f i 2 25 "23 25" int4_to_char - _null_ )); +DATA(insert OID = 1773 ( to_char PGNSP PGUID 12 f f t f s 2 25 "23 25" int4_to_char - _null_ )); DESCR("format int4 to text"); -DATA(insert OID = 1774 ( to_char PGNSP PGUID 12 f f t f i 2 25 "20 25" int8_to_char - _null_ )); +DATA(insert OID = 1774 ( to_char PGNSP PGUID 12 f f t f s 2 25 "20 25" int8_to_char - _null_ )); DESCR("format int8 to text"); -DATA(insert OID = 1775 ( to_char PGNSP PGUID 12 f f t f i 2 25 "700 25" float4_to_char - _null_ )); +DATA(insert OID = 1775 ( to_char PGNSP PGUID 12 f f t f s 2 25 "700 25" float4_to_char - _null_ )); DESCR("format float4 to text"); -DATA(insert OID = 1776 ( to_char PGNSP PGUID 12 f f t f i 2 25 "701 25" float8_to_char - _null_ )); +DATA(insert OID = 1776 ( to_char PGNSP PGUID 12 f f t f s 2 25 "701 25" float8_to_char - _null_ )); DESCR("format float8 to text"); -DATA(insert OID = 1777 ( to_number PGNSP PGUID 12 f f t f i 2 1700 "25 25" numeric_to_number - _null_ )); +DATA(insert OID = 1777 ( to_number PGNSP PGUID 12 f f t f s 2 1700 "25 25" numeric_to_number - _null_ )); DESCR("convert text to numeric"); DATA(insert OID = 1778 ( to_timestamp PGNSP PGUID 12 f f t f s 2 1184 "25 25" to_timestamp - _null_ )); DESCR("convert text to timestamp with time zone"); |