Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on PostgreSQL 10 Beta 1 Released. Parent comment
WHERE lower(email) = lower('[email protected]')
I'm not sure ILIKE can hit an index in your example.
I'm not sure ILIKE can hit an index in your example.