<HTML><DIV class=bgcolor STYLE="background-color: ;"><DIV>
<DIV>Hi Chris,</DIV>
<DIV> </DIV>
<DIV>the query below works for me -</DIV>
<DIV> </DIV>
<DIV>select * from TABLENAME where 'TEXT' ~ pattern;</DIV>
<DIV> </DIV>
<DIV>Thanks for helping!</DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV> </DIV>
<DIV>chris smith writes: </DIV>
<DIV></DIV>
<DIV>> On 4/14/06, pgdb <PGDB(at)GAWAB(dot)COM>wrote: </DIV>
<DIV>>> </DIV>
<DIV>>> </DIV>
<DIV>>> Hi Andreas, </DIV>
<DIV>>> </DIV>
<DIV>>> strange but I don't see html from my original
email received from the </DIV>
<DIV>>> mailing list, hope this reply is ok:) </DIV>
<DIV>>> </DIV>
<DIV>>> If I'm not wrong, the example you've provided is
trying to return matching </DIV>
<DIV>>> rows from multiple patterns and texts as inputs in
the regex search. </DIV>
<DIV>>> </DIV>
<DIV>>> The text in regular expression have to be just a
single string(with no white </DIV>
<DIV>>> character) for my case. Matching should then be
done with patterns from each </DIV>
<DIV>>> row, returning the row(s) that contain matching
regex pattern(s). Appreciate </DIV>
<DIV>>> any advice. Thanks. </DIV>
<DIV>> </DIV>
<DIV>> This page might be what you're after: </DIV>
<DIV>> </DIV>
<DIV>>
http://www.postgresql.org/docs/8.1/static/functions-matching.html
</DIV>
<DIV>> </DIV>
<DIV>> -- </DIV>
<DIV>> Postgresql & php tutorials </DIV>
<DIV>> http://www.designmagick.com/ </DIV>
<DIV></DIV>
<DIV></DIV></DIV></DIV></HTML>
<DIV>________________________________</DIV>
<DIV>Free POP3 Email from <a href="http://www.gawab.com"
target="_blank">www.gawab.com</a></DIV>
<DIV>Sign up NOW and get your account @gawab.com!!</DIV>