Postgres Pro
Downloads
Home   >   mailing lists

Re: match one word - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: match one word
Date
Msg-id 20020909122452.056f2c5e.alvherre@atentus.com
Whole thread Raw
In response to match one word  ("Ben-Nes Michael" <miki@canaan.co.il>)
List pgsql-general
Tree view 
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"

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Load sharing question
Next
From: Jan Ploski
Date:
Subject: Re: Creating tons of tables to support a query