Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 553489FB2AA for ; Mon, 2 Oct 2006 19:22:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 74556-04 for ; Mon, 2 Oct 2006 19:22:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hs5.cfa.cmu.edu (HS5.CFA.cmu.edu [128.2.103.215]) by postgresql.org (Postfix) with ESMTP id EFBB59FA474 for ; Mon, 2 Oct 2006 19:22:42 -0300 (ADT) Received: from [192.168.100.102] (host82.155.212.198.conversent.net [155.212.198.82]) (authenticated bits=0) by hs5.cfa.cmu.edu (8.12.11.20060308/8.12.11) with ESMTP id k92MMfSm002867 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NO) for ; Mon, 2 Oct 2006 18:22:41 -0400 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <45218F90.1050303@logix-tt.com> References: <45218F90.1050303@logix-tt.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <794403F6-6CB5-4726-806C-5EF76D64C7E3@themactionfaction.com> Content-Transfer-Encoding: 7bit From: AgentM Subject: Re: timestamptz alias Date: Mon, 2 Oct 2006 18:22:39 -0400 To: PostgreSQL-development hackers X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.066 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/75 X-Sequence-Number: 91972 On Oct 2, 2006, at 18:15 , Markus Schaber wrote: > 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? I am pleased that the documentation promotes database-independent ("standard") SQL. -M