Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 961089FB289
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Tue,  3 Oct 2006 06:20:50 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 38091-04 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Tue,  3 Oct 2006 09:20:46 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id BD8B69FB27F
	for <pgsql-hackers@postgresql.org>;
	Tue,  3 Oct 2006 06:20:45 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com
	(84-72-188-217.dclient.hispeed.ch [84.72.188.217])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 2989065978
	for <pgsql-hackers@postgresql.org>;
	Tue,  3 Oct 2006 11:23:08 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 04BA7181B2EBB
	for <pgsql-hackers@postgresql.org>;
	Tue,  3 Oct 2006 11:20:41 +0200 (CEST)
Message-ID: <45222B63.2070608@logix-tt.com>
Date: Tue, 03 Oct 2006 11:20:35 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Thunderbird 1.5.0.5 (X11/20060812)
MIME-Version: 1.0
Cc: PostgreSQL-development hackers <pgsql-hackers@postgresql.org>
Subject: Re: timestamptz alias
References: <45218F90.1050303@logix-tt.com>
	<794403F6-6CB5-4726-806C-5EF76D64C7E3@themactionfaction.com>
	<34B58049-42F3-468D-AA2A-AE79DC8FB244@decibel.org>
In-Reply-To: <34B58049-42F3-468D-AA2A-AE79DC8FB244@decibel.org>
X-Enigmail-Version: 0.94.0.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature";
	boundary="------------enig4E5A11356A29FB13C5478FB2"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200610/119
X-Sequence-Number: 92016

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig4E5A11356A29FB13C5478FB2
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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
--=20
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

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


--------------enig4E5A11356A29FB13C5478FB2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFIitoyHQIGEs7eeARAwqWAJwPlWfZhsFYTLmfihQzz+ELCvP5ZQCguEkB
TvLQ/2Eq5v8chFCOq6MMILk=
=+F5Z
-----END PGP SIGNATURE-----

--------------enig4E5A11356A29FB13C5478FB2--