![]() ![]() With predicates on lower(description) anycodings_pattern-matching exclusively, the expression index is the anycodings_pattern-matching slightly better option. Or with the case-insensitive regexp anycodings_pattern-matching operator (without % wildcards): description ~* 'abc'Īn index on (description) does not anycodings_pattern-matching support queries on lower(description) anycodings_pattern-matching like: lower(description) LIKE '%abc%' When working with said trigram index anycodings_pattern-matching it's typically more practical to work anycodings_pattern-matching with: description ILIKE '%abc%'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |