Pradeep Chodisettibackend.engg.wiki·Jan 18, 2024Text and Pattern matching in PostgresText matching is a pretty common problem while working with SQL. LIKE, SIMILAR TO and POSIX are pretty common querying use cases. But, taking advantage of indexes when using these is something to pay attention to. A simple b-tree index on a text/varc...37 readsPostgreSQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.