X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id C85649FA4A7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 30 Jun 2006 09:31:13 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 47922-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 30 Jun 2006 09:31:08 -0300 (ADT)
X-Greylist: delayed 16:30:20.000222 by SQLgrey-
Received: from webmail.getloaded.com (lb2.getloaded.com [8.7.97.12])
	by postgresql.org (Postfix) with ESMTP id 0C5689FA163
	for <pgsql-sql@postgresql.org>; Fri, 30 Jun 2006 09:31:07 -0300 (ADT)
Received: from [192.168.1.9] (uslec-66-255-131-12.cust.uslec.net
	[66.255.131.12]) (authenticated bits=0)
	by webmail.getloaded.com (8.12.11.20060308/8.12.11) with ESMTP id
	k5UCV1V6030674; Fri, 30 Jun 2006 08:31:02 -0400
Message-ID: <44A51994.5040506@getloaded.com>
Date: Fri, 30 Jun 2006 08:31:16 -0400
From: Jason Farmer <jfarmer@getloaded.com>
User-Agent: Thunderbird 1.5.0.4 (X11/20060615)
MIME-Version: 1.0
To: Richard Broersma Jr <rabroersma@yahoo.com>
CC: Erik Jones <erik@myemma.com>,
	General Postgresql List <pgsql-sql@postgresql.org>
Subject: Re: Using In Clause For a Large Text Matching Query
References: <20060630001738.11455.qmail@web31801.mail.mud.yahoo.com>
In-Reply-To: <20060630001738.11455.qmail@web31801.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/330
X-Sequence-Number: 25566

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