> Well, there is also: <a
> href="http://www.postgresql.org/docs/8.1/interactive/functions-comparisons.html#AEN13377";>
>
> /expression/ /operator/ ANY (/array expression/)</a>. So, if you have a way
> to preprocess you
> input text fields that you want matched
> you could build a regex for each and feed them in an array to an '~ ANY'
> expression like so (or,
> use ~* for case
> insensitive matching):
>
> SELECT col1
> FROM table
> WHERE col1 ~ ANY (ARRAY['regex1', 'regex2', ...]);
Good point, But don't forget to include the list in your response. :-)
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
