James - don't repeat the whole of the previous message in your replies, trim it to the relevant part. The message is already archived on the list. James Dooley wrote: > Oleg, but I am only interested in whether or not the syntax of my > search-query is correct. > > Having created the index as I mentioned above, would the correct way of > searching and using that index be > > ... AND (title || '' || description || '' || name) @@ plainto_tsquery('car') That looks like a correct syntax, but it's unlikely to use your index - your index was created on to_tsvector('my_config', ...) > or should it be as Richard just mentioned > > ... AND to_tsvector(title || '' || description || '' || name) @@ > plainto_tsquery('car') > > or some other way ? Try playing around with the example I gave, and try variations on it. Do you understand why you have to supply a config when creating the functional index? Do you understand the difference between plainto_tsquery() and to_tsquery()? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general