Apply (a somewhat revised version of) Greg Mullane's patch to eliminate

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 9c2a7c2269d1ecebd7f83e769bb2640cb82fa0e0

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2003-07-29T00:03:19Z

Apply (a somewhat revised version of) Greg Mullane's patch to eliminate
heuristic determination of day vs month in date/time input.  Add the
ability to specify that input is interpreted as yy-mm-dd order (which
formerly worked, but only for yy greater than 31).  DateStyle's input
component now has the preferred spellings DMY, MDY, or YMD; the older
keywords European and US are now aliases for the first two of these.
Per recent discussions on pgsql-general.

Files

Path	Change	+/−
doc/src/sgml/datatype.sgml	modified	+77 −68
doc/src/sgml/datetime.sgml	modified	+16 −39
doc/src/sgml/func.sgml	modified	+2 −2
doc/src/sgml/ref/postgres-ref.sgml	modified	+5 −6
doc/src/sgml/ref/set.sgml	modified	+4 −3
doc/src/sgml/ref/show.sgml	modified	+2 −2
doc/src/sgml/release.sgml	modified	+3 −1
doc/src/sgml/runtime.sgml	modified	+12 −4
src/backend/commands/variable.c	modified	+45 −29
src/backend/tcop/postgres.c	modified	+4 −4
src/backend/utils/adt/datetime.c	modified	+129 −97
src/backend/utils/init/globals.c	modified	+2 −2
src/backend/utils/misc/guc.c	modified	+5 −5
src/backend/utils/misc/postgresql.conf.sample	modified	+1 −1
src/backend/utils/misc/README	modified	+3 −3
src/bin/psql/tab-complete.c	modified	+5 −3
src/include/miscadmin.h	modified	+34 −16
src/test/regress/expected/horology-no-DST-before-1970.out	modified	+23 −18
src/test/regress/expected/horology.out	modified	+23 −18
src/test/regress/expected/horology-solaris-1947.out	modified	+23 −18
src/test/regress/expected/timestamp.out	modified	+3 −1
src/test/regress/expected/timestamptz.out	modified	+3 −1
src/test/regress/pg_regress.sh	modified	+3 −3
src/test/regress/sql/horology.sql	modified	+8 −4
src/test/regress/sql/timestamp.sql	modified	+3 −1
src/test/regress/sql/timestamptz.sql	modified	+3 −1