Re: [PERFORM] NOT LIKE much faster than LIKE?

[Christopher Kings-Lynne]

        UNLIKELY string LIKE '%% PREEMPT %%'

or:

        LIKELY string NOT LIKE '%% PREEMPT %%'

You should be using contrib/tsearch2 for an un-anchored text search perhaps?


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org