Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id EC8339FB3B2
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Fri,  6 Oct 2006 04:36:01 -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 03132-08 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Fri,  6 Oct 2006 04:35:59 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr.mydnsbox.com (svr.mydnsbox.com [216.40.201.219])
	by postgresql.org (Postfix) with ESMTP id CF3189FB3A0
	for <pgsql-hackers@postgresql.org>;
	Fri,  6 Oct 2006 04:35:58 -0300 (ADT)
Received: from www.dunslane.net (localhost.localdomain [127.0.0.1])
	by svr.mydnsbox.com (8.13.1/8.13.1) with ESMTP id k967ZtLJ026170;
	Fri, 6 Oct 2006 02:35:55 -0500
Received: from 24.211.165.134
	(SquirrelMail authenticated user andrew@dunslane.net)
	by www.dunslane.net with HTTP; Fri, 6 Oct 2006 02:35:55 -0500 (CDT)
Message-ID: <3449.24.211.165.134.1160120155.squirrel@www.dunslane.net>
In-Reply-To: <06013250-FEB2-431C-9EE9-DB4CB037FE9E@enterprisedb.com>
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>
Date: Fri, 6 Oct 2006 02:35:55 -0500 (CDT)
Subject: Re: timestamptz alias
From: "Andrew Dunstan" <andrew@dunslane.net>
To: "Jim Nasby" <jimn@enterprisedb.com>
Cc: "PostgreSQL-development hackers" <pgsql-hackers@postgresql.org>
User-Agent: SquirrelMail/1.4.6
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.371 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200610/329
X-Sequence-Number: 92226

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?

cheers

andrew