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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
