Jeff Amiel <jamiel@istreamimaging.com> writes:
> If postgres knows the field is an int8, why do I have to cast it in my query?
As of 8.0 you won't have to anymore.
You don't really want to know why it took us six years to find a
workable solution... suffice it to say that it was harder than you
might think, because of Postgres' extensible approach to datatypes.
regards, tom lane