pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tk421 <vrobador@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Pattern Matchig
Date: Tue, 08 Apr 2008 19:39:38 +0200
Message-ID: <47FBADDA.8040709@gmail.com> (raw)
In-Reply-To: <20080408172409.GJ9062@alvh.no-ip.org>
References: <47FBA7F0.3000300@gmail.com>
	<20080408172409.GJ9062@alvh.no-ip.org>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Alvaro Herrera escribi&oacute;:
<blockquote cite="mid:20080408172409.GJ9062@alvh.no-ip.org" type="cite">
  <pre wrap="">Tk421 escribi&oacute;:

  </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 ~ '[[:&lt;:]]foobar[[:&gt;:]]'

  </pre>
</blockquote>
Thank you very much, it worked!<br>
<br>
Gracias, &Aacute;lvaro<br>
</body>
</html>

view thread (3+ messages)

Message-ID: <47FBADDA.8040709@gmail.com>
Permalink:  ../47FBADDA.8040709@gmail.com/
Also on:    postgresql.org/message-id/47FBADDA.8040709@gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: vrobador@gmail.com, alvherre@commandprompt.com
  Subject: Re: Pattern Matchig
  In-Reply-To: <47FBADDA.8040709@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox