Tiger Data, the creators of TimescaleDB, announced that its open-source BM25 search engine, pg_textsearch, is now supported natively in Google Cloud’s AlloyDB and Cloud SQL for PostgreSQL databases.
where @searchPhraseis currently an NVARCHAR(1000) and holds the result of a function call that puts together the full search phrase. This all works fine as is but a long search string will increase ...