From 63cb35c41c62ffab5749eeb81105b78beacef3f9 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 29 May 2006 23:29:38 +0000 Subject: [PATCH] Add: > o Allow timezone names in SQL strings, '2006-05-24 21:11 > Americas/New_York'::timestamptz --- doc/TODO | 4 +++- doc/src/FAQ/TODO.html | 4 +++- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/doc/TODO b/doc/TODO index a1dfda7553..3abe70bb0f 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Wed May 24 14:12:19 EDT 2006 +Last updated: Mon May 29 19:29:26 EDT 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -230,6 +230,8 @@ Data Types If the TIMESTAMP value is stored with a time zone name, interval computations should adjust based on the time zone rules. + o Allow timezone names in SQL strings, '2006-05-24 21:11 + Americas/New_York'::timestamptz o Fix SELECT '0.01 years'::interval, '0.01 months'::interval o Add a GUC variable to allow output of interval values in ISO8601 format diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index a5a1d4cc7f..85261ec388 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Wed May 24 14:12:19 EDT 2006 +Last updated: Mon May 29 19:29:26 EDT 2006

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -211,6 +211,8 @@ first.

If the TIMESTAMP value is stored with a time zone name, interval computations should adjust based on the time zone rules.

+
  • Allow timezone names in SQL strings, '2006-05-24 21:11 + Americas/New_York'::timestamptz
  • Fix SELECT '0.01 years'::interval, '0.01 months'::interval
  • Add a GUC variable to allow output of interval values in ISO8601 format -- 2.11.0