Re: Using In Clause For a Large Text Matching Query

Ah, I do think that sounds about like what I want! Let me play with this
one some, thanks so much!!

Richard Broersma Jr wrote:
>> 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
>
>