"Daniel J. Summers" <daniel@xxxxxxxxxxxxxxxxxx> writes: > MySQL will only use it if the wildcard isn't in the front (1) and > requires the MATCH keyword to search full-text indexes (2), Oracle > requires special "full-text" indexes to be able to use for LIKE (3) > (actually dealt with that at work a few months back), SQL Server only > uses it under certain conditions (4), and even 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. Only if you're using a non-C locale. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
