From bfd0cd5568e8fe039cb002bcf97d1d2dd67f6493 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 25 Feb 2010 18:16:53 +0000 Subject: [PATCH] Clearly document that timestamp alone means timestamp without timezone, per SQL standard, and mention 7.3 behavior at the end. --- doc/src/sgml/datatype.sgml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index f866bee8db..8e25700a17 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,4 +1,4 @@ - + Data Types @@ -1523,9 +1523,11 @@ SELECT E'\\xDEADBEEF'; - Prior to PostgreSQL 7.3, writing just - timestamp was equivalent to timestamp with - time zone. This was changed for SQL compliance. + The SQL standard requires that writing just timestamp + be equivalent to timestamp without time + zone, and PostgreSQL honors that + behavior. (Releases prior to 7.3 treated it as timestamp + with time zone.) -- 2.40.0