Re: Pattern Matchig - Mailing list pgsql-sql

From Tk421
Subject Re: Pattern Matchig
Date
Msg-id 47FBADDA.8040709@gmail.com
Whole thread Raw
In response to Re: Pattern Matchig  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
Alvaro Herrera escribió: <blockquote cite="mid:20080408172409.GJ9062@alvh.no-ip.org" type="cite"><pre wrap="">Tk421
escribió:
 </pre><blockquote type="cite"><pre wrap="">   The result is only record number 3. How can i search the entire  
FOOBAR word? The result wanted must be all, excepting 5.   </pre></blockquote><pre wrap="">
Something like this:

select code from table where text ~ '[[:<:]]foobar[[:>:]]'
 </pre></blockquote> Thank you very much, it worked!<br /><br /> Gracias, Álvaro<br />

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pattern Matchig
Next
From: novice
Date:
Subject: count question