Re: Using In Clause For a Large Text Matching Query

[Richard Broersma Jr <rabroersma(at)yahoo(dot)com>]

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