Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C78BF9FB223 for ; Sun, 8 Oct 2006 14:03:35 -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 64812-06 for ; Sun, 8 Oct 2006 17:03:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id BCF019FA0B9 for ; Sun, 8 Oct 2006 14:03:28 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 40E1456437; Sun, 8 Oct 2006 12:03:27 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Sun, 8 Oct 2006 12:03:26 -0500 Date: Sun, 8 Oct 2006 12:03:26 -0500 From: "Jim C. Nasby" To: Andrew Dunstan Cc: Jim Nasby , PostgreSQL-development hackers Subject: Re: timestamptz alias Message-ID: <20061008170325.GI72517@nasby.net> 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> <452381C8.5090804@logix-tt.com> <4523C28F.4080404@dunslane.net> <4523D8B1.7050007@logix-tt.com> <06013250-FEB2-431C-9EE9-DB4CB037FE9E@enterprisedb.com> <3449.24.211.165.134.1160120155.squirrel@www.dunslane.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3449.24.211.165.134.1160120155.squirrel@www.dunslane.net> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:061008:andrew@dunslane.net::RUIBcQfALTH+kUvv:000000000000000000 00000000000000000000000017Vf X-Hashcash: 1:20:061008:jimn@enterprisedb.com::nA/PC6UOvNV8Xm20:0000000000000000 0000000000000000000000007ZXZ X-Hashcash: 1:20:061008:pgsql-hackers@postgresql.org::k5ekqrRO/Km0RUnd:000000000 0000000000000000000000000utJ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/406 X-Sequence-Number: 92303 On Fri, Oct 06, 2006 at 02:35:55AM -0500, Andrew Dunstan wrote: > Jim Nasby wrote: > > > > It would be nice to denote types/aliases that are and aren't ANSI. A > > number are marked in the docs, but it would be good to add the info > > to that summary table. > > Right under the table this sentence appears: > > Compatibility: The following types (or spellings thereof) are specified > by SQL: bit, bit varying, boolean, char, character varying, character, > varchar, date, double precision, integer, interval, numeric, decimal, > real, smallint, time (with or without time zone), timestamp (with or > without time zone). > > What's unclear about that? Oops. This is what happens when I answer emails on a plane. :( -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)