Andro <andromede@xxxxxxxxx> writes:
> they both require "paramTypes" parameter, but documentation says "If
> paramTypes is NULL, or any particular element in the array is zero,
> the server assigns a data type to the parameter symbol in the same way
> it would do for an untyped literal string."
> How reliable is that? Can we really leave out this parameter anytime?
Like it says, you get the same results you would get from writing a
literal string 'foo' where the parameter symbol is. If you like,
you can force the type decision with a cast in the query text, eg
"SELECT ... WHERE x = $1::int8 ... "
In some ways this is better than using paramTypes because you don't
have to mess with numeric OIDs for data types.
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
|
