Skip site navigation (1) Skip section navigation (2)

pgsql/ oc/src/sgml/datatype.sgml rc/backend/pa ...

From: tgl(at)postgresql(dot)org
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/ oc/src/sgml/datatype.sgml rc/backend/pa ...
Date: 2001-11-12 21:04:46
Message-ID: 200111122104.fACL4kT31915@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql
Changes by:	tgl(at)postgresql(dot)org	01/11/12 16:04:46

Modified files:
	doc/src/sgml   : datatype.sgml 
	src/backend/parser: analyze.c gram.y 
	src/backend/utils/adt: format_type.c 

Log message:
	Tweak parser so that there is a defined representation for datatypes
	bpchar, bit, numeric with typmod -1.  Alter format_type so that this
	representation is printed when the typmod is -1.  This ensures that
	tables having such columns can be pg_dump'd and reloaded correctly.
	Also, remove the rather useless and non-SQL-compliant default
	precision and scale for type NUMERIC.  A numeric column declared as
	such (with no precision/scale) will now have typmod -1 which means
	that numeric values of any precision/scale can be stored in it,
	without conversion to a uniform scale.  This seems significantly
	more useful than the former behavior.  Part of response to bug #513.


pgsql-committers by date

Next:From: Tom LaneDate: 2001-11-12 21:29:36
Subject: Re: pgsql/src/backend/optimizer/prep prepunion.c
Previous:From: Bruce MomjianDate: 2001-11-12 20:29:03
Subject: Re: pgsql/src/backend/optimizer/prep prepunion.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group