Re: Coercion in PGSQL?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Max Ueda <mhanzo(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Coercion in PGSQL?
Date: 2007-01-16 20:27:06
Message-ID: 20070116202706.GA29844@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 16, 2007 at 04:14:26 -0800,
Max Ueda <mhanzo(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-01-16 20:31:32 Re: Multi-column constraint behaviour
Previous Message Bertram Scharpf 2007-01-16 20:18:09 Multi-column constraint behaviour