Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TXooq-0005iX-Rb for pgsql-sql@postgresql.org; Mon, 12 Nov 2012 07:52:33 +0000 Received: from adsltrust.ath.forthnet.gr ([194.219.204.174] helo=smadev.internal.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TXoon-0004KS-4T for pgsql-sql@postgresql.org; Mon, 12 Nov 2012 07:52:32 +0000 X-Bogosity: No, tests=bogofilter Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.5/8.14.5) with ESMTP id qAC7qQUo057378 for ; Mon, 12 Nov 2012 09:52:26 +0200 (EET) (envelope-from achill@smadev.internal.net) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id qAC7qQgu057377 for pgsql-sql@postgresql.org; Mon, 12 Nov 2012 09:52:26 +0200 (EET) (envelope-from achill@smadev.internal.net) From: Achilleas Mantzios To: pgsql-sql@postgresql.org Reply-To: Achilleas Mantzios Subject: Re: find sudstring on text (data type) field failure Date: Mon, 12 Nov 2012 09:52:26 +0200 Message-ID: <2124145.U7R12LdlNH@smadev.internal.net> Organization: Dynacom Tankers Mgmt User-Agent: KMail/4.8.4 (FreeBSD/8.3-RELEASE; KDE/4.8.4; amd64; ; ) In-Reply-To: References: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="nextPart2540392.rXDM8038ns" Content-Transfer-Encoding: 7Bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/12 X-Sequence-Number: 36945 --nextPart2540392.rXDM8038ns Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" Gia sou Panteli, are you suggesting that the results are incinsistent and unpredictable = with every run? pls present a case demontsrating the problem. On =CE=A4=CE=B5=CF=84 07 =CE=9D=CE=BF=CE=B5 2012 10:36:34 pantelis vlac= hos wrote: I was trying to find a substring on a text (data type) column like 'cat= foo dog ...'.=20 I use the query below SELECT id FROM table WHERE name LIKE '% foo %'; Sometimes the query return with nTuples=3D0 but there are matching rows= . On retry, the query return with expected results. Any ideas; (postgres ver 9.2, libpq - C Library) - Achilleas Mantzios IT DEPT --nextPart2540392.rXDM8038ns Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="UTF-8"

Gia= sou Panteli,

are= you suggesting that the results are incinsistent and unpredictable wit= h every run?

pls= present a case demontsrating the problem.

On = =CE=A4=CE=B5=CF=84 07 =CE=9D=CE=BF=CE=B5 2012 10:36:34 pantelis vlachos= wrote:

I was trying to find a substring on a text (data type) column like 'ca= t foo dog ...'.
I use the query below
SELECT id FROM table W= HERE name LIKE '% foo %';
Sometimes the query return with nTuples=3D= 0 but there are matching rows.
On retry, the query return with exp= ected results. Any ideas;

(postgres ver 9.2, libpq - C Libra= ry)

Ach= illeas Mantzios

IT = DEPT

--nextPart2540392.rXDM8038ns--