Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group