"Christopher Condit" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
