Hi Chris,

 

the query below works for me -

 

select * from TABLENAME where 'TEXT' ~ pattern;

 

Thanks for helping!

 

Regards

 

chris smith writes:

> On 4/14/06, pgdb 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/