On Mar 30, 2004, at 2:38 PM, Jesse Vincent wrote:
> What is the right way to do fast case-insensitive comparisons in
> postgres that take database indexes into account?
make your index functional on lower(column) and then compare
lower(column) = lower('string'). don't just index on the column
directly.