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/
________________________________
Free POP3 Email from www.gawab.com
Sign up NOW and get your account @gawab.com!!
