Re: timestamptz alias

Hi, Jim,

Jim Nasby wrote:

> There's a difference between promoting and withholding info. I'd rather
> see us explicitly state which is preferred and why.

Here's a small patch that adds an appropriate explanation.

Index: doc/src/sgml/datatype.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v
retrieving revision 1.176
diff -u -r1.176 datatype.sgml
--- doc/src/sgml/datatype.sgml 22 Sep 2006 16:20:00 -0000 1.176
+++ doc/src/sgml/datatype.sgml 3 Oct 2006 09:14:32 -0000
@@ -1372,6 +1372,17 @@
</para>
</note>

+ <note>
+ <para>
+ <productname>PostgreSQL</productname> also supports the aliases
+ <type>timestamptz</type> for <type>timestamp with time zone</type>
+ and <type>timetz</type> for <type>time with time zone</type>. It
+ is recommended to avoid them, as the more verbose variants comply
+ to the SQL standard, and thus are more portable. But there are no
+ plans to drop the short aliases in future versions.
+ </para>
+ </note>
+
<para>
<type>time</type>, <type>timestamp</type>, and
<type>interval</type> accept an optional precision value

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org