Re: Full text search - wildcard and a stop word

2022-02-22 Thread Tom Lane
Allan Jardine writes: > => select to_tsquery('all:*'); > NOTICE: text-search query contains only stop words or doesn't contain > lexemes, ignored > to_tsquery > > (1 row) > I get why that is happening - the notification basically details it, but > the wildcard at the end seems to m

Full text search - wildcard and a stop word

2022-02-22 Thread Allan Jardine
Hi all, I'm venturing into full text search in Postgres for the first time, and I'd like to be able to do a search by the start of a word - so I used the `:*` operator. However, this doesn't operate as I'd expect with a stop word - for example, my name is "Allan" so I often use it as a test string