On Fri, 30 Oct 1998, Jerome Knobl wrote:
> I tried btree and hash method, but when I make a clause like : where nom
> like '%PICASSO%'; the request don't use any index!?!
Check the FAQ, question 3.10 (or thereabouts). Text searches only use
the index if they are searching for text at the start of the field.
In response to
pgsql-sql by date
|Next:||From: pgateau .||Date: 1998-10-30 19:08:42|
|Subject: sql libpq access to varchar column|
|Previous:||From: Jerome Knobl||Date: 1998-10-30 15:38:55|
|Subject: How can I optimize a research on text field?|