"Robert Osowiecki" <[EMAIL PROTECTED]> writes: > BUT when on "where ar_code = 'FOO'" unique_code_i index is used and query > returns NO ROWS!
Could you be more specific? Which values of 'FOO' does this happen for? What is the datatype of ar_code? If it's a string type, what locale and encoding are you using? You have not given nearly enough information to let anyone else reproduce the problem. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend