From: Achilleas Mantzios <achill@smadev.internal.net>
To: pgsql-sql@postgresql.org
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> (raw)
In-Reply-To: <CAAYHi_cTqLi9iP_x6_5pV+Jd+wYD2Ak08bF--0oJGk0yqUSUaA@mail.gmail.com>
References: <CAAYHi_cTqLi9iP_x6_5pV+Jd+wYD2Ak08bF--0oJGk0yqUSUaA@mail.gmail.com>
Gia sou Panteli,
are you suggesting that the results are incinsistent and unpredictable with every run?
pls present a case demontsrating the problem.
On Τετ 07 Νοε 2012 10:36:34 pantelis vlachos wrote:
I was trying to find a substring on a text (data type) column like 'cat foo dog ...'.
I use the query below
SELECT id FROM table WHERE name LIKE '% foo %';
Sometimes the query return with nTuples=0 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
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: achill@smadev.internal.net
Subject: Re: find sudstring on text (data type) field failure
In-Reply-To: <2124145.U7R12LdlNH@smadev.internal.net>
* 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