Daniel J. Summers wrote: > Andrzej Zawadzki wrote: >> Daniel J. Summers wrote: >> >>> Tony Liao wrote: >>> >>>> I try to explain analyze,but it doesn't work ,it use seq scan. >>>> >>> Generally speaking, LIKE doesn't use indexes. >>> >> ?! That's not true at all!! >> [...] > PostgreSQL (the great subject of this mailing list) doesn't do it with > a standard index (5) - you've got to use a special operator class.
Please try... with "C" locales. Works out of the box. -- Andrzej Zawadzki -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
