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
