Re: [HACKERS] 7.0.3 reproduceable serious select error

[Tom Lane]

[EMAIL PROTECTED] (Rob van Nieuwkerk) writes:
> The problem is that a SELECT with a certain LIKE condition in combination
> with a GROUP BY does not find the proper records when there is an index on
> the particular column present.  When the index is removed the SELECT *does*
> return the right answer.

Are you running the postmaster in a non-ASCII locale?  This sounds like
the old LIKE index optimization problem that we've struggled with for
quite a while now.  7.1 works around it by disabling the optimization
in non-ASCII locales, which is unpleasant but at least it gives right
answers ...

                        regards, tom lane