pgsql-server/ oc/src/sgml/catalogs.sgml oc/src ... - Mailing list pgsql-committers
From | tgl@postgresql.org (Tom Lane) |
---|---|
Subject | pgsql-server/ oc/src/sgml/catalogs.sgml oc/src ... |
Date | |
Msg-id | 20020918213525.9AA084766AB@postgresql.org Whole thread Raw |
List | pgsql-committers |
CVSROOT: /cvsroot Module name: pgsql-server Changes by: tgl@postgresql.org 02/09/18 17:35:25 Modified files: doc/src/sgml : catalogs.sgml datatype.sgml release.sgml typeconv.sgml doc/src/sgml/ref: create_cast.sgml src/backend/catalog: heap.c pg_aggregate.c pg_proc.c src/backend/commands: functioncmds.c indexcmds.c src/backend/executor: nodeAgg.c src/backend/nodes: copyfuncs.c equalfuncs.c makefuncs.c outfuncs.c readfuncs.c src/backend/optimizer/path: indxpath.c pathkeys.c src/backend/optimizer/plan: createplan.c src/backend/optimizer/prep: preptlist.c prepunion.c src/backend/parser: analyze.c gram.y keywords.c parse_clause.c parse_coerce.c parse_expr.c parse_func.c parse_node.c parse_oper.c parse_target.c src/backend/rewrite: rewriteHandler.c src/backend/utils/adt: arrayfuncs.c int8.c numeric.c regproc.c ruleutils.c varbit.c varchar.c src/backend/utils/cache: lsyscache.c src/bin/initdb : initdb.sh src/bin/pg_dump: pg_dump.c src/include/catalog: catversion.h pg_cast.h pg_operator.h pg_proc.h src/include/nodes: makefuncs.h parsenodes.h primnodes.h src/include/parser: parse_coerce.h parse_node.h parse_target.h src/include/utils: array.h builtins.h int8.h lsyscache.h varbit.h src/test/regress/expected: domain.out horology-no-DST-before-1970.out horology-solaris-1947.out horology.out opr_sanity.out prepare.out rules.out strings.out union.out src/test/regress/sql: domain.sql horology.sql opr_sanity.sql strings.sql Log message: Extend pg_cast castimplicit column to a three-way value; this allows us to be flexible about assignment casts without introducing ambiguity in operator/function resolution. Introduce a well-defined promotion hierarchy for numeric datatypes (int2->int4->int8->numeric->float4->float8). Change make_const to initially label numeric literals as int4, int8, or numeric (never float8 anymore). Explicitly mark Func and RelabelType nodes to indicate whether they came from a function call, explicit cast, or implicit cast; use this to do reverse-listing more accurately and without so many heuristics. Explicit casts to char, varchar, bit, varbit will truncate or pad without raising an error (the pre-7.2 behavior), while assigning to a column without any explicit cast will still raise an error for wrong-length data like 7.3. This more nearly follows the SQL spec than 7.2 behavior (we should be reporting a 'completion condition' in the explicit-cast cases, but we have no mechanism for that, so just do silent truncation). Fix some problems with enforcement of typmod for array elements; it didn't work at all in 'UPDATE ... SET array[n] = foo', for example. Provide a generalized array_length_coerce() function to replace the specialized per-array-type functions that used to be needed (and were missing for NUMERIC as well as all the datetime types). Add missing conversions int8<->float4, text<->numeric, oid<->int8. initdb forced.
pgsql-committers by date: