Re: regular expression question

I wish everyone would use the same syntax...it's getting to the point
where you need a reference book for everybody's idea of how regex should
be done.

-d

Alvaro Herrera wrote:

>Parker Thompson dijo:
>
>
>
>>I have a question regarding regular expression with postgres.
>>
>>I am unable to find any reference to match on word boundaries (\b in
>>perl). If this functionality exists in postgres I am interested in
>>knowing how to use it, an example would probably suffice.
>>
>>If it does not, which is what I suspect, I am interested in knowing how
>>others have dealt with this problem. It seems silly/ineffecient to just
>>try all cases, i.e. field ~* (^term| term | term$), but I can't think of a
>>better way.
>>
>>
>
>You can use [[:<:]] and [[:>:]] as word boundaries.
>
>
>