Changes between Initial Version and Version 1 of Ticket #34840, comment 10
- Timestamp:
- Sep 16, 2023, 5:44:04 AM (9 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #34840, comment 10
initial v1 13 13 14 14 Though that begs the next question: Assume you generate an index for a text column named `x`. Would a query with `.filter(x__startswith='test')` use the index if the index is created on `x` but the query uses `x::text like 'test%'`? 15 16 EDIT:// The `next` question might be a non issue generate `x like 'test%'::text` -- Nevertheless it feels a bit unfortunate that postgresql cannot use the index with the cast.