DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type:content-transfer-encoding;
	b=KVMwoZEAK0as6K/Y2H8LQMggMeT3RoSCEHJq5FFGtNmzXsgqKkDCnbXRvD8wSH3yyg
	cUHACdMDKasZ2UHxuDkktL9d4JxWnAaKvCAnyYBRisoQy005ua0FQR4w8VqoDBNcVPTo
	aYse+3DF0oqDNsjJEZz0K1LrKL7hQnzRBdNZA=
MIME-Version: 1.0
In-Reply-To: <11645.1277257777@sss.pgh.pa.us>
References: <4C207403.3080103@gmail.com>
	<AANLkTikX89l8iqkpcAJvxlJl5fP7dvyhmrHU8oer-lfY@mail.gmail.com>
	<20100622230754.GE15203@fetter.org>
	<AANLkTilfZooZpo_GqnAZHE9e_yk_KhVOmpU1AT-V-WW_@mail.gmail.com>
	<11645.1277257777@sss.pgh.pa.us>
From: Thom Brown <thombrown@gmail.com>
Date: Wed, 23 Jun 2010 09:17:58 +0100
Message-ID: <AANLkTilq-UVd-seYgasLkH4TjRwG8WHTw-EhLxyyxOQD@mail.gmail.com>
Subject: Re: INTEGER range ("-2147483648" is not accepted.)
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Fetter <david@fetter.org>,
	Satoshi Nagayasu <satoshi.nagayasu@gmail.com>, pgsql-docs@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 23 June 2010 02:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thom Brown <thombrown@gmail.com> writes:
>> Is that the right behaviour though? =A0Shouldn't the signed value reach
>> the cast step rather than the absolute value? =A0Or maybe Postgres could
>> implicitly accept -12345::integer to be (-12345)::integer. =A0Is there a
>> blocking reason as to why it must work this way?
>
> Yes. =A0There is no reason to assume that - means the same thing for ever=
y
> datatype. =A0In general, :: should (and does) bind tighter than *every*
> operator, to ensure that the appropriately typed operator is applied.
>

Okay.  I'll admit that this won't be a common case, but could the
error message make reference to the value it took?

Thom