public inbox for [email protected]  

help / color / mirror / Atom feed

From: Markus Schaber <[email protected]>
Cc: PostgreSQL-development hackers <[email protected]>
Subject: Re: timestamptz alias
Date: Tue, 03 Oct 2006 11:20:35 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

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



Attachments:

  [application/pgp-signature] signature.asc (252B, 2-signature.asc)
  download

view thread (18+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: timestamptz alias
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox