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 C7CA69FA5F0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Jun 2006 21:17:48 -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 93283-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Jun 2006 21:17:40 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web31801.mail.mud.yahoo.com (web31801.mail.mud.yahoo.com
	[68.142.207.64]) by postgresql.org (Postfix) with SMTP id 7681A9FA5DD
	for <pgsql-sql@postgresql.org>; Thu, 29 Jun 2006 21:17:39 -0300 (ADT)
Received: (qmail 11457 invoked by uid 60001); 30 Jun 2006 00:17:38 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=EDqJW23gVrj0Kmpt/smsn9AoMLekfoQCf+7OG9eoeQqenRko6YFWVm8zLKbGyKIvMBTpNQMbV3awpsDmRWYXjQJGLLlyhyl5gQNIa3Fwl1dFH27xL4s7FM3G6ALHsfT8g5exXHW+ZnxxMZhsqs1cG0l4G4Gw3pXtuyVHsTB9w+g=
	;
Message-ID: <20060630001738.11455.qmail@web31801.mail.mud.yahoo.com>
Received: from [24.54.196.198] by web31801.mail.mud.yahoo.com via HTTP;
	Thu, 29 Jun 2006 17:17:38 PDT
Date: Thu, 29 Jun 2006 17:17:38 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Using In Clause For a Large Text Matching Query
To: Erik Jones <erik@myemma.com>
Cc: General Postgresql List <pgsql-sql@postgresql.org>
In-Reply-To: <44A4572C.6080008@myemma.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/324
X-Sequence-Number: 25560

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