Word boundaries in regular expressions

Started by Troy Rasiahabout 18 years ago2 messagesgeneral
Jump to latest
#1Troy Rasiah
troyr@vicnet.net.au

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

--
Troy Rasiah

#2Thomas Pundt
mlists@rp-online.de
In reply to: Troy Rasiah (#1)
Re: Word boundaries in regular expressions

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