Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B58EC9FB26A for ; Tue, 3 Oct 2006 13:14:18 -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 38547-10 for ; Tue, 3 Oct 2006 16:14:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from community1.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 40FF89FB21B for ; Tue, 3 Oct 2006 13:14:04 -0300 (ADT) Received: from [192.168.27.150] ([12.38.10.44]) (authenticated bits=0) by community1.commandprompt.com (8.13.5.20060308/8.13.5/Debian-3ubuntu1.1) with ESMTP id k93GDlcc002614 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Tue, 3 Oct 2006 09:13:53 -0700 Message-ID: <45228C3A.2090704@dunslane.net> Date: Tue, 03 Oct 2006 12:13:46 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.6) Gecko/20060804 Fedora/1.0.4-0.5.1.fc5 SeaMonkey/1.0.4 MIME-Version: 1.0 To: Tom Lane CC: Markus Schaber , PostgreSQL-development hackers Subject: Re: timestamptz alias References: <45218F90.1050303@logix-tt.com> <794403F6-6CB5-4726-806C-5EF76D64C7E3@themactionfaction.com> <34B58049-42F3-468D-AA2A-AE79DC8FB244@decibel.org> <45222B63.2070608@logix-tt.com> <26117.1159889582@sss.pgh.pa.us> In-Reply-To: <26117.1159889582@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/139 X-Sequence-Number: 92036 Tom Lane wrote: > Markus Schaber writes: > >> Here's a small patch that adds an appropriate explanation. >> > > If we're going to document these aliases, what of float4, float8, and bool? > Also, although the docs mention int2/int4/int8, it's more or less left > to the reader's imagination to deduce what they are. > > Perhaps it'd be better to provide a small table of recognized type > aliases, rather than inserting equivalent notes into three or four places. > > you mean like the table here? http://momjian.us/main/writings/pgsql/sgml/datatype.html cheers andrew