Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE without wildcard different from = - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: LIKE without wildcard different from =
Date
Msg-id 4C59564902000025000341CF@gw.wicourts.gov
Whole thread Raw
In response to Re: LIKE without wildcard different from =  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Ah.  Well, the real fix for that is also in 8.4: we got rid of the
> separate ~=~ operator, so a text_pattern_ops index is now usable
> for plain =.

Nice!

Thanks,

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: LIKE without wildcard different from =
Next
From: Hannu Krosing
Date:
Subject: Re: Questions on query planner, join types, and work_mem