Re: query planner: automatic rescribe of LIKE to BETWEEN ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: query planner: automatic rescribe of LIKE to BETWEEN ?
Date
Msg-id 11769.1156281153@sss.pgh.pa.us
Whole thread Raw
In response to query planner: automatic rescribe of LIKE to BETWEEN ?  (Ulrich Habel <espero7757@gmx.net>)
List pgsql-performance
Ulrich Habel <espero7757@gmx.net> writes:
> Anythings speeks against this hack?

Only that it was done years ago.

As Alvaro mentions, if you are using a non-C locale then you need
non-default index opclasses to get it to work.  Non-C locales usually
have index sort orders that don't play nice with this conversion.

            regards, tom lane

pgsql-performance by date:

Previous
From: Charles Sprickman
Date:
Subject: Benchmarks
Next
From: Jeff Davis
Date:
Subject: PowerEdge 2950 questions