Re: match one word

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: match one word
Date: 2002-09-09 16:24:52
Message-ID: 20020909122452.056f2c5e.alvherre@atentus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

En Mon, 9 Sep 2002 12:16:42 +0200
"Ben-Nes Michael" <miki(at)canaan(dot)co(dot)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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Ploski 2002-09-09 16:47:55 Re: Creating tons of tables to support a query
Previous Message Johnson, Shaunn 2002-09-09 16:09:55 Load sharing question