I'm trying to match a DB record (operation) that contains a slash with no results.

The operation name field that I'm trying to search contains:

some /word

This is the search:

  SELECT "operations"."id" FROM "operations" 
  WHERE (((
            'simple', coalesce("operations"."name" :: text, '')
        ) @@ (
          to_tsquery( 'simple', ''' ' || 'word' || ' ''' || ':*')

I think that psql is indexing '/word' as a file path and not including it as a result.

Is this posible on psql ?


I find that regex is a great help. You might look at the following page https://www.postgresql.org/docs/9.3/functions-matching.html and get the the whole word beginning with a slash.

Alpha only:




Using "ts_debug", you can see that you are correct, it is considering this to be part of a file path and so is indexing only as '/word' and not 'word' itself, so then searching on 'word' will not find '/word'. You could create your own parser which would emit both '/word' and 'word', or just 'word', if you wanted. But that is not exactly trivial to do.

There are probably better solutions, but it is hard to recommend one because your question is hard to understand. What kind of a db record is an "operation"? If you know you are searching for a thing with a slash, why not just include the slash in the ts_query?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.