Re: Query appears not to recognise index (enable_seqscan=off)

Excellent - Nailed it - Thanks!

On Tue, Apr 28, 2009 at 5:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Neil Saunders <n.j.saunders@gmail.com> writes:
>> And we're still running the sequential scan - My questions is why?
>
> You're probably not in C locale.  Change locale or use a
> text_pattern_ops index instead of a plain index on lower(name).
> See
> http://wiki.postgresql.org/wiki/FAQ#Why_are_my_queries_slow.3F_Why_don.27t_they_use_my_indexes.3F
>
>                        regards, tom lane
>