Changes between Initial Version and Version 1 of Ticket #8519, comment 9
- Timestamp:
- Dec 23, 2009, 12:01:56 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #8519, comment 9
initial v1 1 1 Replying to [comment:8 cboos]: 2 > Well, I expect the speed should be in the same league with the explicit comparison than with the "between", as it will also be able to make good use of the index.2 > ... So my next suggestion would be to drop the idea of separate `like()` and `ilike()` altogether, and keep `like()` case-insensitive. 3 3 4 Verified. It's funny that such a simple trick would bring three orders of magnitude of improvement. 5 6 The other interesting thing is that this reduces the need for a case-sensitive `like()` to... no occurrences at all! So my next suggestion would be to drop the idea of separate `like()` and `ilike()` altogether, and keep `like()` case-insensitive. 4 Ha! Lazyness attack! But I have to agree, let's defer making the `like`/`ilike` distinction to when it becomes really needed. If not already done, we should also make sure the docstring for `like()` correctly highlights its case-insensitiveness.