Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 4A68F2E0038
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue,  8 Apr 2008 14:46:30 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 93304-02
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue,  8 Apr 2008 14:46:22 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.190])
	by developer.postgresql.org (Postfix) with ESMTP id 1F91F2E002C
	for <pgsql-sql@postgresql.org>; Tue,  8 Apr 2008 14:46:21 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id f5so861483nfh.23
	for <pgsql-sql@postgresql.org>; Tue, 08 Apr 2008 10:46:20 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	bh=X0nMJY63hVp8UQvBKx2vscQBJl09X8mUWLpKbmkeTHk=;
	b=XmyRRX7gOmCOFwwT+KU3WGPTEAT3Bc17T+qXUSvnGDU3/4JxR4XqO0ThMl8Lb+hxcoCgub8nqUocMHfjHCKkZoZSF2x21T1NwvNljk/bF+h5Z+dkIYHXSkspFTn9dRqwXGyECPcYdSz32siO9wfGsO46upjDQs4LPG9NV4GVw0c=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=rT5+P+5+lArr7a/tugfwzl3kE1Z9bJWVoIjAcjIEBiVQ0Ud0cjiIp7srym9l89sdmMPkEm3pEkQYujbc41MCUxFxeyMIIVZGk3+5e8D8SkGH4Fx69s6Jc7tiTKjEOgATjt/Bwpa92H76zfwUsDEN5IXn9rLZWnd2ZA50jCMvt6k=
Received: by 10.78.161.4 with SMTP id j4mr13301431hue.35.1207676382475;
	Tue, 08 Apr 2008 10:39:42 -0700 (PDT)
Received: from ?192.168.1.5? ( [87.222.7.173])
	by mx.google.com with ESMTPS id k5sm16193405nfd.23.2008.04.08.10.39.39
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Tue, 08 Apr 2008 10:39:40 -0700 (PDT)
Message-ID: <47FBADDA.8040709@gmail.com>
Date: Tue, 08 Apr 2008 19:39:38 +0200
From: Tk421 <vrobador@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Pattern Matchig
References: <47FBA7F0.3000300@gmail.com>
 <20080408172409.GJ9062@alvh.no-ip.org>
In-Reply-To: <20080408172409.GJ9062@alvh.no-ip.org>
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.837 tagged_above=0 required=5 tests=AWL=-0.837,
	HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.672
X-Spam-Level: 
X-Archive-Number: 200804/53
X-Sequence-Number: 30592

<!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>