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
signature.asc
Description: OpenPGP digital signature