From qtboyzz@yahoo.com Sun Feb  6 10:12:57 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C879C8B9B33
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 10:12:57 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 03166-08
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 10:12:46 +0000 (GMT)
Received: from web61003.mail.yahoo.com (web61003.mail.yahoo.com
	[216.155.196.92])
	by svr1.postgresql.org (Postfix) with SMTP id A440C8B9E06
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 10:12:46 +0000 (GMT)
Received: (qmail 28650 invoked by uid 60001); 6 Feb 2005 10:12:46 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	b=M20Fxi5buXFdsx5KtNf2F2757ZAKgYKLRtGMqWUIAPp/wieyqOA7GDxTomLDviS85ZKWIpPQCMQq5cKmwr142VcREUsvriWhahG+w79Ttg6YhaSobUrpYmtiwiWyPYRtuqzPA9Bcm/mYP5OIWyfMwofAZ8B3EavXYkCq+0qI4C0=
	;
Message-ID: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
Received: from [67.121.104.217] by web61003.mail.yahoo.com via HTTP;
	Sun, 06 Feb 2005 02:12:46 PST
Date: Sun, 6 Feb 2005 02:12:46 -0800 (PST)
From: b t <qtboyzz@yahoo.com>
Subject: How to search for a subString
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1435358049-1107684766=:27070"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.879 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200502/8
X-Sequence-Number: 5253

--0-1435358049-1107684766=:27070
Content-Type: text/plain; charset=us-ascii

Hi, I'm building a database for a school project and I want to search for the name of the movie,  fro example in the database there is a table called movie and has a movie call "The fast and the furious" so if the type in "the fast" then it should return that movie. I tried using like and ilike and it still would not work.
Thanks in advance
-BT

		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'
--0-1435358049-1107684766=:27070
Content-Type: text/html; charset=us-ascii

<DIV>Hi, I'm building a database for a school project and I want to search for the name of the movie,&nbsp; fro example in the database there is a table called movie and has a movie call "The fast and the furious" so if the type in "the fast" then it should return that movie. I tried using like and ilike and it still would not work.</DIV>
<DIV>Thanks in advance</DIV>
<DIV>-BT</DIV><p>
		<hr size=1>Do you Yahoo!?<br> 
Yahoo! Search presents - <a href="http://us.rd.yahoo.com/evt=30648/*http://movies.yahoo.com/movies/feature/jibjabinaugural.html">Jib Jab's 'Second Term'</a>
--0-1435358049-1107684766=:27070--



From andreas_kretschmer@despammed.com Sun Feb  6 10:44:11 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 981958B9E06
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 10:44:11 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 05576-02
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 10:43:59 +0000 (GMT)
Received: from md1.psixpress.com (md1.psixpress.com [154.32.105.205])
	by svr1.postgresql.org (Postfix) with ESMTP id E85C98B9BBB
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 10:43:59 +0000 (GMT)
Received: from kaufbach.delug.de (pD9EB3C9B.dip0.t-ipconnect.de
	[217.235.60.155]) by md1.psixpress.com (MOS 3.5.6-GR)
	with ESMTP id CNL53727 (AUTH via LOGINBEFORESMTP);
	Sun, 6 Feb 2005 10:43:56 GMT
Received: from kretschmer by kaufbach.delug.de with local (Exim 3.35 #1)
	id 1Cxjuq-0000tQ-00
	for pgsql-interfaces@postgresql.org; Sun, 06 Feb 2005 11:45:20 +0100
Date: Sun, 6 Feb 2005 11:45:20 +0100
From: Kretschmer Andreas <andreas_kretschmer@despammed.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Message-ID: <20050206104520.GA3405@kaufbach.delug.de>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
User-Agent: Mutt/1.3.28i
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B  3B86 4DB3 D9EE 7F45 84DA
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the
	answer is "no"!
X-Lugdd: Gerd Kube
X-Info: My name is root. Just root. And I am licensed to kill -9
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200502/9
X-Sequence-Number: 5254

am  Sun, dem 06.02.2005, um  2:12:46 -0800 mailte b t folgendes:
> Hi, I'm building a database for a school project and I want to search for the
> name of the movie,  fro example in the database there is a table called movie
> and has a movie call "The fast and the furious" so if the type in "the fast"
> then it should return that movie. I tried using like and ilike and it still

select .. ~ '*the fast*' ...


Regards, Andreas
-- 
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)



From bruno@wolff.to Sun Feb  6 13:17:52 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 84EA98B9E09
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 13:17:52 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 15917-07
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 13:17:39 +0000 (GMT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id B8C908B9E2A
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 13:17:39 +0000 (GMT)
Received: (qmail 2204 invoked by uid 500); 6 Feb 2005 13:32:20 -0000
Date: Sun, 6 Feb 2005 07:32:20 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Kretschmer Andreas <andreas_kretschmer@despammed.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Message-ID: <20050206133220.GB952@wolff.to>
Mail-Followup-To: Kretschmer Andreas <andreas_kretschmer@despammed.com>,
	pgsql-interfaces@postgresql.org
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
	<20050206104520.GA3405@kaufbach.delug.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050206104520.GA3405@kaufbach.delug.de>
User-Agent: Mutt/1.5.6i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/10
X-Sequence-Number: 5255

On Sun, Feb 06, 2005 at 11:45:20 +0100,
  Kretschmer Andreas <andreas_kretschmer@despammed.com> wrote:
> am  Sun, dem 06.02.2005, um  2:12:46 -0800 mailte b t folgendes:
> > Hi, I'm building a database for a school project and I want to search for the
> > name of the movie,  fro example in the database there is a table called movie
> > and has a movie call "The fast and the furious" so if the type in "the fast"
> > then it should return that movie. I tried using like and ilike and it still
> 
> select .. ~ '*the fast*' ...

That should be:
select .. ~ '.*the fast.*' ...

As REs are unanchored, you can simplify this to:
select .. ~ 'the fast' ...

However, ilike should have worked if it was used properly.

Also note that these searches are going to be slow, since they won't
be able to use an index. If you have so many movies that the speed of
the search is unacceptably slow, then you might want to look at the
tsearch2 contrib module.



From postgresql@finner.de Sun Feb  6 15:04:18 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 266BA8B9E41
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 15:04:18 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 23996-09
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 15:04:02 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.187])
	by svr1.postgresql.org (Postfix) with ESMTP id B5A568B9D97
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 15:04:02 +0000 (GMT)
Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1Cxnx8-0005Ag-00; Sun, 06 Feb 2005 16:03:58 +0100
Received: from [80.146.129.93] (helo=lorien.finner.de)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1Cxnx7-0001LE-00; Sun, 06 Feb 2005 16:03:58 +0100
Received: from isengard.finner.de (isengard.finner.de [192.168.14.20])
	by lorien.finner.de (Invenius Mailomatics) with SMTP
	id 88FED56FE9; Sun,  6 Feb 2005 16:03:50 +0100 (CET)
Date: Sun, 6 Feb 2005 16:03:48 +0100
From: Frank Finner <postgresql@finner.de>
To: Bruno Wolff III <bruno@wolff.to>
Cc: andreas_kretschmer@despammed.com, pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Message-Id: <20050206160348.059c695b.postgresql@finner.de>
In-Reply-To: <20050206133220.GB952@wolff.to>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
	<20050206104520.GA3405@kaufbach.delug.de>
	<20050206133220.GB952@wolff.to>
Organization: Invenius Frank Finner
X-Mailer: Sylpheed version 1.0.0 (GTK+ 1.2.10; x86_64-unknown-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: base64
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	auth:2d1f62c261f062640f582804a7b1040c
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=MIME_BASE64_TEXT
X-Spam-Level: 
X-Archive-Number: 200502/11
X-Sequence-Number: 5256

RG8gUkVzIGF1dG9tYXRpY2FsbHkgaWdub3JlIGNhc2U/IE90aGVyd2lzZSBpdCBpcyBjbGVhciB0
aGF0IH4gJ3RoZQ0KZmFzdCcgY2Fubm90IGZpbmQgJ1RoZSBmYXN0IGFuZCB0aGUgZnVyaW91cycu
IFRoZSBzZWFyY2gNCmV4cHJlc3Npb25zIHNob3VsZCBiZSBhbGwgdXBwZXJjYXNlZCBvciBsb3dl
cmNhc2VkIHRoZW4uDQoNClJlZ2FyZHMsIEZyYW5rLg0KDQpPbiBTdW4sIDYgRmViIDIwMDUgMDc6
MzI6MjAgLTA2MDAgQnJ1bm8gV29sZmYgSUlJIDxicnVub0B3b2xmZi50bz4NCnRob3VnaHQgbG9u
ZywgdGhlbiBzYXQgZG93biBhbmQgd3JvdGU6DQoNCj4gQXMgUkVzIGFyZSB1bmFuY2hvcmVkLCB5
b3UgY2FuIHNpbXBsaWZ5IHRoaXMgdG86DQo+IHNlbGVjdCAuLiB+ICd0aGUgZmFzdCcgLi4uDQo+
DQo+IEhvd2V2ZXIsIGlsaWtlIHNob3VsZCBoYXZlIHdvcmtlZCBpZiBpdCB3YXMgdXNlZCBwcm9w
ZXJseS4NCi0tIA0KRnJhbmsgRmlubmVyDQpL9nBmY2hlbnN0cmHfZSAzNg0KNTcwNzIgU2llZ2Vu
DQo=



From andreas_kretschmer@despammed.com Sun Feb  6 15:10:43 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id B51E18B9B31
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 15:10:43 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 24667-07
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 15:10:28 +0000 (GMT)
Received: from md1.psixpress.com (md1.psixpress.com [154.32.105.205])
	by svr1.postgresql.org (Postfix) with ESMTP id 04D148B9CF6
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 15:10:30 +0000 (GMT)
Received: from kaufbach.delug.de (pD9EB3C9B.dip0.t-ipconnect.de
	[217.235.60.155]) by md1.psixpress.com (MOS 3.5.6-GR)
	with ESMTP id CNL88609 (AUTH via LOGINBEFORESMTP);
	Sun, 6 Feb 2005 15:10:28 GMT
Received: from kretschmer by kaufbach.delug.de with local (Exim 3.35 #1)
	id 1Cxo4f-0001H5-00
	for pgsql-interfaces@postgresql.org; Sun, 06 Feb 2005 16:11:45 +0100
Date: Sun, 6 Feb 2005 16:11:45 +0100
From: Kretschmer Andreas <andreas_kretschmer@despammed.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Message-ID: <20050206151145.GA4865@kaufbach.delug.de>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
	<20050206104520.GA3405@kaufbach.delug.de>
	<20050206133220.GB952@wolff.to>
	<20050206160348.059c695b.postgresql@finner.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20050206160348.059c695b.postgresql@finner.de>
User-Agent: Mutt/1.3.28i
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B  3B86 4DB3 D9EE 7F45 84DA
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the
	answer is "no"!
X-Lugdd: Gerd Kube
X-Info: My name is root. Just root. And I am licensed to kill -9
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200502/12
X-Sequence-Number: 5257

am  Sun, dem 06.02.2005, um 16:03:48 +0100 mailte Frank Finner folgendes:
> Do REs automatically ignore case? Otherwise it is clear that ~ 'the

No.


> fast' cannot find 'The fast and the furious'. The search
> expressions should be all uppercased or lowercased then.

Correct.

~  : Case-sensitive
~* : ignore case

!~ and !~* are negative


Regards, Andreas
-- 
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)



From Darko.Prenosil@finteh.hr Sun Feb  6 18:21:46 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 26B308B9EB6
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 18:21:46 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 41525-02
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sun,  6 Feb 2005 18:21:37 +0000 (GMT)
Received: from mxout2.iskon.hr (mxout2.iskon.hr [213.191.128.16])
	by svr1.postgresql.org (Postfix) with SMTP id B107D8B9E96
	for <pgsql-interfaces@postgresql.org>;
	Sun,  6 Feb 2005 18:21:36 +0000 (GMT)
Received: (qmail 21901 invoked from network); 6 Feb 2005 19:21:34 +0100
X-Remote-IP: 213.191.142.122
Received: from unknown (HELO mx.iskon.hr) (213.191.142.122)
	by mxout2.iskon.hr with SMTP; 6 Feb 2005 19:21:34 +0100
Received: (qmail 27346 invoked from network); 6 Feb 2005 19:21:34 +0100
X-Remote-IP: 213.191.138.133
Received: from zg05-132.dialin.iskon.hr (HELO serverd) (213.191.138.133)
	by mx.iskon.hr with SMTP; 6 Feb 2005 19:21:33 +0100
Message-ID: <001e01c50c78$68eb3120$0600a8c0@serverd>
From: "Darko Prenosil" <Darko.Prenosil@finteh.hr>
To: "b t" <qtboyzz@yahoo.com>, <pgsql-interfaces@postgresql.org>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
Subject: Re: How to search for a subString
Date: Sun, 6 Feb 2005 19:18:55 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001B_01C50C80.B321EF60"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200502/13
X-Sequence-Number: 5258

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C50C80.B321EF60
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

You probably did not use correct syntax for LIKE, try with=20
SELECT * FROM movie WHERE name LIKE '%the%fast%';

In the future if You want help from this list, be more specific about =
the problem, send some example, error message or such, not just =
explanation: "It does not work !"

Regards !

  ----- Original Message -----=20
  From: b t=20
  To: pgsql-interfaces@postgresql.org=20
  Sent: Sunday, February 06, 2005 11:12 AM
  Subject: [INTERFACES] How to search for a subString


  Hi, I'm building a database for a school project and I want to search =
for the name of the movie,  fro example in the database there is a table =
called movie and has a movie call "The fast and the furious" so if the =
type in "the fast" then it should return that movie. I tried using like =
and ilike and it still would not work.
  Thanks in advance
  -BT


-------------------------------------------------------------------------=
-----
  Do you Yahoo!?
  Yahoo! Search presents - Jib Jab's 'Second Term'
------=_NextPart_000_001B_01C50C80.B321EF60
Content-Type: text/html;
	charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>You probably did not use correct syntax =
for LIKE,=20
try with </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>SELECT * FROM movie WHERE name LIKE=20
'%the%fast%';</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>In the future if You want help from =
this list, be=20
more specific about the problem, send some example, error message or =
such, not=20
just explanation: "It does not work !"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A title=3Dqtboyzz@yahoo.com href=3D"mailto:qtboyzz@yahoo.com">b t</A> =
</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
  title=3Dpgsql-interfaces@postgresql.org=20
  =
href=3D"mailto:pgsql-interfaces@postgresql.org">pgsql-interfaces@postgres=
ql.org</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Sunday, February 06, 2005 =
11:12=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [INTERFACES] How to =
search for a=20
  subString</DIV>
  <DIV><BR></DIV>
  <DIV>Hi, I'm building a database for a school project and I want to =
search for=20
  the name of the movie,&nbsp; fro example in the database there is a =
table=20
  called movie and has a movie call "The fast and the furious" so if the =
type in=20
  "the fast" then it should return that movie. I tried using like and =
ilike and=20
  it still would not work.</DIV>
  <DIV>Thanks in advance</DIV>
  <DIV>-BT</DIV>
  <P>
  <HR SIZE=3D1>
  Do you Yahoo!?<BR>Yahoo! Search presents - <A=20
  =
href=3D"http://us.rd.yahoo.com/evt=3D30648/*http://movies.yahoo.com/movie=
s/feature/jibjabinaugural.html">Jib=20
  Jab's 'Second Term'</A></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_001B_01C50C80.B321EF60--




From bruno@wolff.to Mon Feb  7 14:21:20 2005
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CFD958B9E6E
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Mon,  7 Feb 2005 14:21:20 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 67651-03
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Mon,  7 Feb 2005 14:21:06 +0000 (GMT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id D81DF8B9CF7
	for <pgsql-interfaces@postgresql.org>;
	Mon,  7 Feb 2005 14:21:09 +0000 (GMT)
Received: (qmail 29005 invoked by uid 500); 7 Feb 2005 14:35:55 -0000
Date: Mon, 7 Feb 2005 08:35:55 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Frank Finner <postgresql@finner.de>
Cc: andreas_kretschmer@despammed.com, pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Message-ID: <20050207143555.GA28894@wolff.to>
Mail-Followup-To: Frank Finner <postgresql@finner.de>,
	andreas_kretschmer@despammed.com, pgsql-interfaces@postgresql.org
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
	<20050206104520.GA3405@kaufbach.delug.de>
	<20050206133220.GB952@wolff.to>
	<20050206160348.059c695b.postgresql@finner.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050206160348.059c695b.postgresql@finner.de>
User-Agent: Mutt/1.5.6i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/14
X-Sequence-Number: 5259

On Sun, Feb 06, 2005 at 16:03:48 +0100,
  Frank Finner <postgresql@finner.de> wrote:
> Do REs automatically ignore case? Otherwise it is clear that ~ 'the
> fast' cannot find 'The fast and the furious'. The search
> expressions should be all uppercased or lowercased then.

No they don't. I missed that when following up to the previous suggestion.
You need to use the ~* operator instead of ~ to get case insensitive
regular expressions.