|
Say I have the following parameterized query in a function: select * from foo where ($1 = -1 or
foo.status = $1) and (…) where the (…) part consists of more parameterized
conditions similar to the first one. Suppose that at runtime, $1 is supplied a value of -1, does
the foo.status = $1 condition still have to be evaluated? Assuming the $1 = -1 case, should the above query be as fast
as the following? select * from foo where (…) Thanks |
