Coercion in PGSQL?

From: Max Ueda <mhanzo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Coercion in PGSQL?
Date: 2007-01-16 12:14:26
Message-ID: 20070116121426.51868.qmail@web53414.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've been wondering with some wrong results that are
being returned from some functions in my application.
Basically, they are algebraic functions dealing with
int values.

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?

Thanks in advance

Max Ueda


____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2007-01-16 13:08:29 Need help on SP
Previous Message Richard Huxton 2007-01-16 10:07:07 Re: Very long "or" where clause