Re: Using In Clause For a Large Text Matching Query

> 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.