aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2010-12-15 20:52:31 -0500
committerRobert Haas <rhaas@postgresql.org>2010-12-15 20:53:40 -0500
commitafc8f47b5885716db716a2523c00f7465cb7f415 (patch)
tree3ab90ba10b11132f0ff9d2cd87603723a45bdf51
parent03db44eae3e065174d5e29888b8d98c39b1f520b (diff)
downloadpostgresql-afc8f47b5885716db716a2523c00f7465cb7f415.tar.gz
postgresql-afc8f47b5885716db716a2523c00f7465cb7f415.zip
Document timestamptz a little better.
-rw-r--r--doc/src/sgml/datatype.sgml7
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 66aef156082..edb0384694d 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1443,6 +1443,9 @@ SELECT E'\\xDEADBEEF';
<primary>timestamp</primary>
</indexterm>
<indexterm zone="datatype-datetime">
+ <primary>timestamptz</primary>
+ </indexterm>
+ <indexterm zone="datatype-datetime">
<primary>timestamp with time zone</primary>
</indexterm>
<indexterm zone="datatype-datetime">
@@ -1535,7 +1538,9 @@ SELECT E'\\xDEADBEEF';
be equivalent to <type>timestamp without time
zone</type>, and <productname>PostgreSQL</productname> honors that
behavior. (Releases prior to 7.3 treated it as <type>timestamp
- with time zone</type>.)
+ with time zone</type>.) <type>timestamptz</type> is taken as an
+ abbreviation for <type>timestamp with time zone</type>; this is a
+ <productname>PostgreSQL</productname> extension.
</para>
</note>