Changes between Initial Version and Version 1 of Ticket #35778, comment 12


Ignore:
Timestamp:
Oct 2, 2024, 1:22:55 PM (6 weeks ago)
Author:
john-parton

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #35778, comment 12

    initial v1  
    22
    33So with respect to my open PR, it sounds like we should use the double-colon as well, in the (probably unlikely case) that the field in question has an index on it. Based on what you said, if we use "CAST(%(expression)s)" it might result in an index a user defined with the expectation it be used, going unused due to the text not being exactly the same in the query. Make sense?
     4
     5Quick edit: As I typed this out, I realized I'm not sure when Postgres would even _use_ an index in the context of JSONObject. That seems extremely unlikely actually.
Back to Top