News for hackers. Stuff that matters.

A comment on What’s so exciting about Postgres?. Parent comment

Re:What’s so exciting about Postgres? by gigatexal on Friday October 30, 2020 @04:48PM (#24946756)
Case insensitive search is accomplished with ILIKE no?
[ Parent | on HN ]
Re:What’s so exciting about Postgres? by johannes1234321 on Friday October 30, 2020 @08:17PM (#24948034)
How well does ILIKE work with indexes? In MySQL the collation (which includes case- and accent-independency options) is known to the index.
[ Parent | on HN ]
Re:What’s so exciting about Postgres? by spacemanmatt on Saturday October 31, 2020 @06:31AM (#24950292)
You can stipulate the collation in the query if you need something non-default.
[ Parent | on HN ]