Jeff Amiel <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org