Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 494CD1337C60 for ; Tue, 7 Dec 2010 15:35:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 54528-03-6 for ; Tue, 7 Dec 2010 19:35:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 0CAFB1337F03 for ; Tue, 7 Dec 2010 15:21:10 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id D5287348023; Tue, 7 Dec 2010 11:21:04 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Efq9Uxg+Dm5Q; Tue, 7 Dec 2010 11:21:02 -0800 (PST) Received: from perhan.alvh.no-ip.org (unknown [200.85.201.29]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id D521E348022; Tue, 7 Dec 2010 11:21:01 -0800 (PST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id BF2D3763C9; Tue, 7 Dec 2010 16:20:53 -0300 (CLST) Content-Type: text/plain; charset=UTF-8 Cc: Chris , pgsql-docs Subject: Re: Is timestamptz alias documented? From: Alvaro Herrera To: Tom Lane In-reply-to: <25686.1291746953@sss.pgh.pa.us> References: <25686.1291746953@sss.pgh.pa.us> Date: Tue, 07 Dec 2010 16:20:53 -0300 Message-Id: <1291749509-sup-8246@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.324 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_NJABL_PROXY=2.224 X-Spam-Level: X-Archive-Number: 201012/8 X-Sequence-Number: 6244 Excerpts from Tom Lane's message of mar dic 07 15:35:53 -0300 2010: > Chris writes: > > Is this a new alias, or > > has it been around for some time? > > It's been around since the '90s I'm sure, maybe even back to Berkeley days. It appeared later; "timestamp" was the alias for "timestamp with time zone" previously. But this was against the SQL standard so the new alias was introduced as a backwards incompatible change. There are no hits for a "grep -r timestamptz src/backend" in 7.1, but they are there in 7.2. 2002 or so, then. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support