PG Doc comments form <nore...@postgresql.org> writes: > Searching for "the between predicate simplifies range tests" does turn > up a hit for that page, so it's indexed, but the words "The BETWEEN" are > not set in bold in the search result. Perhaps "BETWEEN" is being treated > as a stop word, even though it's capitalized and an SQL keyword?
A quick grep shows that if "between" weren't a stopword, it would produce almost 600 hits in our core docs, most of which are not what you're looking for. So I concur with somebody's apparent decision to make it a stopword. Use the index. regards, tom lane