Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3A9289FA474 for ; Mon, 2 Oct 2006 19:15:53 -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 52702-01 for ; Mon, 2 Oct 2006 22:15:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tacotec.de (mail.tacotec.de [83.137.101.41]) by postgresql.org (Postfix) with ESMTP id 049E29F9DCD for ; Mon, 2 Oct 2006 19:15:47 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.tacotec.de (Postfix) with ESMTP id 2EAE911D8B4 for ; Tue, 3 Oct 2006 00:15:45 +0200 (CEST) Received: from mail.tacotec.de ([83.137.101.41]) by localhost (hera.tacotec.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15468-01 for ; Tue, 3 Oct 2006 00:15:45 +0200 (CEST) Received: from lunix.schabi.de (p549D3DF8.dip0.t-ipconnect.de [84.157.61.248]) by mail.tacotec.de (Postfix) with ESMTP id E311411D5C8 for ; Tue, 3 Oct 2006 00:15:44 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by lunix.schabi.de (Postfix) with ESMTP id 4E1A57FC57 for ; Tue, 3 Oct 2006 00:15:44 +0200 (CEST) Message-ID: <45218F90.1050303@logix-tt.com> Date: Tue, 03 Oct 2006 00:15:44 +0200 From: Markus Schaber User-Agent: Thunderbird 1.5.0.7 (X11/20060915) MIME-Version: 1.0 To: pgsql-hackers@postgresql.org Subject: timestamptz alias X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mail.tacotec.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.134 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200610/73 X-Sequence-Number: 91970 Hi, I'm happy that the rather verbose "timestamp with time zone" has the much nicer alias "timestamptz", however it seems that this alias is not documented, neither at http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html nor at http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html I see it mentioned at http://www.postgresql.org/docs/8.1/interactive/datatype.html but that's possibly not where people look at first, when they search for the timestamp type. (At least I found it only when grepping for "timestamptz" in the docs. :-) Should the alias be mentioned on the datetime page? The same for timetz? What do you think? Thanks, Markus