En Mon, 9 Sep 2002 12:16:42 +0200
"Ben-Nes Michael" <miki@canaan.co.il> escribió:
Hi,
> How can i match pattern of one word ?
>
> I mean "xxxx ", "xxxx", " xxxx", " xxxx "
Try using word boundaries, [[:<:]] and [[:>:]]
'[[:<:]]xxxx[[:>:]]'
http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-REGEXP
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La soledad es compañia"