Kurapica wrote:
I am developing an application which searches for city names in a
column. There is a lot of cities and I have to 'like' every name which
is not effective enough. So I want to know whether pgsql's regex
processor can optimize regexes such as:
Nebraska|Nevada|North Carolina
Kurapica,
I'd use contrib/pg_trgm for your application.
Олег
On Tue, 26 Dec 2006, Alvaro Herrera wrote:
Kurapica wrote:
I am developing an application which searches for city names in a
column. There is a lot of cities and I have to 'like' every name which
is not effective enough. So I want
Alvaro Herrera [EMAIL PROTECTED] writes:
Kurapica wrote:
So I want to know whether pgsql's regex
processor can optimize regexes such as:
Nebraska|Nevada|North Carolina
to
N(e(braska|vada)|orth Carolina)
Compared to the use of indexes to skip whole table scanning, this
optimization is
Hi all.
I am developing an application which searches for city names in a
column. There is a lot of cities and I have to 'like' every name which
is not effective enough. So I want to know whether pgsql's regex
processor can optimize regexes such as:
Nebraska|Nevada|North Carolina
to