]> granicus.if.org Git - postgresql/commit
Add a new GUC variable called "IntervalStyle" that decouples interval output
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Nov 2008 00:28:35 +0000 (00:28 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Nov 2008 00:28:35 +0000 (00:28 +0000)
commitdf7641e25ab4da6f3a48222cbda0e121ccb32ad5
tree29c33ccd2ff2a7b3c2abcd52cede74c79c4c56f7
parenteec501c4f773add9f30789efc28f8ce3bf2e5de9
Add a new GUC variable called "IntervalStyle" that decouples interval output
from DateStyle, and create a new interval style that produces output matching
the SQL standard (at least for interval values that fall within the standard's
restrictions).  IntervalStyle is also used to resolve the conflict between the
standard and traditional Postgres rules for interpreting negative interval
input.

Ron Mayer
18 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/datatype.sgml
doc/src/sgml/libpq.sgml
doc/src/sgml/protocol.sgml
doc/src/sgml/ref/copy.sgml
src/backend/utils/adt/datetime.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/timestamp.c
src/backend/utils/init/globals.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/bin/pg_dump/pg_dump.c
src/bin/psql/tab-complete.c
src/include/miscadmin.h
src/interfaces/libpq/fe-connect.c
src/test/regress/expected/interval.out
src/test/regress/pg_regress.c
src/test/regress/sql/interval.sql