diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-02-25 18:16:53 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-02-25 18:16:53 +0000 |
| commit | bfd0cd5568e8fe039cb002bcf97d1d2dd67f6493 (patch) | |
| tree | aea686f40562b8788c920293d499aa60eb820d34 | |
| parent | 413d34be4e1f47ce52b02a6c60858ef6f1285578 (diff) | |
| download | postgresql-bfd0cd5568e8fe039cb002bcf97d1d2dd67f6493.tar.gz postgresql-bfd0cd5568e8fe039cb002bcf97d1d2dd67f6493.zip | |
Clearly document that timestamp alone means timestamp without timezone,
per SQL standard, and mention 7.3 behavior at the end.
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index f866bee8db5..8e25700a177 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.244 2010/02/24 15:54:31 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.245 2010/02/25 18:16:53 momjian Exp $ --> <chapter id="datatype"> <title id="datatype-title">Data Types</title> @@ -1523,9 +1523,11 @@ SELECT E'\\xDEADBEEF'; <note> <para> - Prior to <productname>PostgreSQL</productname> 7.3, writing just - <type>timestamp</type> was equivalent to <type>timestamp with - time zone</type>. This was changed for SQL compliance. + The SQL standard requires that writing just <type>timestamp</type> + be equivalent to <type>timestamp <emphasis>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>.) </para> </note> |