"Dan McFadyen" <[email protected]> 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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
