Hello 2012/11/8 pantelis vlachos <vlacho...@gmail.com>: > 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;
isn't problem in spaces, so LIKE '% foo %' must fail when symbol is on begin or end? you can check ' ' || name || ' ' LIKE '% foo %' or better - use fulltext instead Regards Pavel Stehule > > (postgres ver 9.2, libpq - C Library) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
