Re: Coercion in PGSQL? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Coercion in PGSQL?
Date
Msg-id 20070116202706.GA29844@wolff.to
Whole thread Raw
In response to Coercion in PGSQL?  (Max Ueda <mhanzo@yahoo.com>)
List pgsql-general
On Tue, Jan 16, 2007 at 04:14:26 -0800,
  Max Ueda <mhanzo@yahoo.com> wrote:
>
> Some results made me think of coercion between int
> types. For example, atributing a int8 value into a
> int2 variable. Does it really happen (coercion)? Is
> the int8 value automatically converted into int2, or
> an error should be returned in that case?

area=> select 99999999999::int8::int2;
ERROR:  smallint out of range

pgsql-general by date:

Previous
From: Bertram Scharpf
Date:
Subject: Multi-column constraint behaviour
Next
From: Tom Lane
Date:
Subject: Re: Multi-column constraint behaviour