Re: Numeric Datatype

"Terence Ingram" <terence@socialchange.net.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