robn(at)verdi(dot)et(dot)tudelft(dot)nl (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