Re: Odd query behavior

"Dan McFadyen" <danm@cryptocard.com> writes:
> I've come across an odd situation. I've had access to a database where a
> the following happens:

What are the plans for the two queries?  If either one involves use of
an index, does disabling the index change the results?

> I do know that server it was running on was Finnish. The database uses a
> UTF8 encoding though, so I don't know what that would make any
> difference.

The other line of thought that suggests is that you've got an
encoding/locale mismatch that's messing up text comparisons.  What's the
server's LC_CTYPE setting, and what PG version is this anyway?
        regards, tom lane