Thread: match one word

match one word

From

"Ben-Nes Michael"

Date:

09 September 2002, 08:17:47

Hi All

How can i match pattern of one word ?

I mean "xxxx ", "xxxx", " xxxx", " xxxx "

Re: match one word

From

Alvaro Herrera

Date:

09 September 2002, 15:37:15

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"