Hi, On October 26, 2019 4:09:29 PM PDT, Vik Fearing <vik.fear...@2ndquadrant.com> wrote: >On 26/10/2019 17:41, Eugen Konkov wrote: >> Hi. >> >> I have noticed that it would be cool to use '==' in place of 'IS >NOT >> DISTICT FROM' >> >> What do you think about this crazy idea? > > >I think this is a terrible idea. The only reason to do this would be >to >index it, but indexes (btree at least) expect STRICT operators, which >this would not be.
It sounds like what's being suggested is just some abbreviated formulation of IS NOT DISTINCT. If implement that way, rather than manually adding non strict operators, I don't think there would be an indexing issue. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
