On Tue, Jan 16, 2007 at 04:14:26 -0800,
  Max Ueda <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to