postgres.git / summary / log / commit / refs

commit    3e1a373e2b102b43faa8bbc4841f7511174e1166
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sat Aug 25 21:44:53 2012 +0000
First released in: 9.3.0

    Allow text timezone designations, e.g. "America/Chicago", when using the
    ISO "T" timestamptz format.


 src/backend/utils/adt/datetime.c | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/src/backend/utils/adt/datetime.c b/src/backend/utils/adt/datetime.c
index 26c6742e8b1..c29b8e10191 100644
--- a/src/backend/utils/adt/datetime.c
+++ b/src/backend/utils/adt/datetime.c
@@ -944,6 +944,16 @@ DecodeDateTime(char **field, int *ftype, int nf,
 				break;
 
 			case DTK_TIME:
+				/*
+				 * This might be an ISO time following a "t" field.
+				 */
+				if (ptype != 0)
+				{
+					/* Sanity check; should not fail this test */
+					if (ptype != DTK_TIME)
+						return DTERR_BAD_FORMAT;
+					ptype = 0;
+				}
 				dterr = DecodeTime(field[i], fmask, INTERVAL_FULL_RANGE,
 								   &tmask, tm, fsec);
 				if (dterr)


[parent: 7514208fbb29]