Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
gigatexal
on Oct 30, 2020
|
parent
|
context
|
favorite
| on:
What’s so exciting about Postgres?
Case insensitive search is accomplished with ILIKE no?
johannes1234321
on Oct 31, 2020
[–]
How well does ILIKE work with indexes? In MySQL the collation (which includes case- and accent-independency options) is known to the index.
spacemanmatt
on Oct 31, 2020
|
parent
[–]
You can stipulate the collation in the query if you need something non-default.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
