"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

Reply via email to