Changes between Initial Version and Version 1 of Ticket #36261, comment 1
- Timestamp:
- Mar 16, 2025, 8:45:49 PM (6 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #36261, comment 1
initial v1 5 5 > It seems that icontains (and iexact etc) comparisons should use ILIKE, which would work fine in this situation 6 6 7 Are you sure of that? It appears that `ILIKE` is explicitly pointed out as not being implemented as [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=85b7efa1cdd63c2fe2b70b725b8285743ee5787f it's unclear whether or not it makes sense].7 Are you sure of that? It appears that `ILIKE` is explicitly pointed out as not being implemented for nondeterministic collation as [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=85b7efa1cdd63c2fe2b70b725b8285743ee5787f it's unclear whether or not it makes sense]. 8 8 9 9 > I have looked through git and ticket history and can't find any discussion of why it's implemented using LIKE instead.