Denis Papathanasiou <denis.papathanasiou@xxxxxxxxx> writes: > Is this because the gin/to_tsvector() index works differently for > to_tsquery() compared to plainto_ts_query() ? Not per se, but maybe looking at the actual outputs of the two function calls would be enlightening. I suspect you'll find that the search conditions you are getting are not equivalent. > Note that I need the plainto_tsquery() form b/c my search phrases will > correspond to exact blocks of text, and therefore they will contain > spaces and punctuation, etc. In that case you haven't understood how text search works at all. It simply doesn't do that. You could possibly follow up a text search for component words with a LIKE or similar comparison to verify that the matches actually contain the desired string. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
