Re: Numeric Datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Terence Ingram" <terence(at)socialchange(dot)net(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Numeric Datatype
Date: 2002-05-23 14:43:13
Message-ID: 5504.1022164993@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Terence Ingram" <terence(at)socialchange(dot)net(dot)au> writes:
> Why is this so?

Numeric literals too large to fit in an int are interpreted as floats.

You can work around the issue by explicitly coercing the literal to
numeric, or by single-quoting it (so that its type is not determined
until after agency_uid is known to be numeric), or by updating to PG
7.2 which uses a slightly different set of type-resolution rules.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-05-23 16:10:44 Bug #675: Is there any way to free up some more space?
Previous Message pgsql-bugs 2002-05-23 14:41:20 Bug #674: JDBC: DatabaseMetaData.getColumns() "feature"