Florian Weimer <[EMAIL PROTECTED]> writes: > Is it possible to create an index to support queries of the form > "column LIKE '%suffix'" (similar to an ordinary index for LIKE > 'prefix%', which I also need)?
Sounds like what you *really* need is full-text search, not half measures ... have you looked at tsearch2? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster