On 4/14/06, pgdb <pgdb@xxxxxxxxx> wrote: > > > Hi Andreas, > > strange but I don't see html from my original email received from the > mailing list, hope this reply is ok:) > > If I'm not wrong, the example you've provided is trying to return matching > rows from multiple patterns and texts as inputs in the regex search. > > The text in regular expression have to be just a single string(with no white > character) for my case. Matching should then be done with patterns from each > row, returning the row(s) that contain matching regex pattern(s). Appreciate > any advice. Thanks. This page might be what you're after: http://www.postgresql.org/docs/8.1/static/functions-matching.html -- Postgresql & php tutorials http://www.designmagick.com/