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
N(e(braska|vada)|orth Carolina)
If the processor can do that like a Dictionary-Tree, it may be
affordable to me or else I have to write a matcher myself.
Any suggestion is appreciated. Thank you and appologize for my poor English.
--Xig