Thread: Word boundaries in regular expressions

Apologies if this has been posted somewhere else but what is the
equivalent of perl's \b in postgres regular expressions ?


--
Troy Rasiah

Troy Rasiah schrieb:
>
> Apologies if this has been posted somewhere else but what is the
> equivalent of perl's \b in postgres regular expressions ?

I think you are looking for \m and \M.

See
http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP

Ciao,
Thomas