"Christopher Condit" <condit@sdsc.edu> writes:
> Although, once you've built the index with varchar_pattern_ops index,
> the following two (essentially equivalent) queries will run at vastly
> different speeds:
> select * from A where A.value like 'Nacho';
> select * from A where A.value = 'Nacho';
> Seems that the optimizer should catch this...
Yeah, it's on the to-do list ...
http://archives.postgresql.org/pgsql-hackers/2008-02/msg01003.php
regards, tom lane