Andrei <[EMAIL PROTECTED]> writes:
> Why when I prepare statement by parsing such query: 'SELECT * FROM
> "test" WHERE "ind" < $1 + 1' ("ind" is of type REAL) $1 is interpreted
> by backend as INTEGER?
Because the context in which its type first has to be resolved is "$1 + 1",
and the "1" is INTEGER.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
