On 10/28/19 8:37 AM, Robert Haas wrote: > On Mon, Oct 28, 2019 at 7:54 AM Isaac Morland <isaac.morl...@gmail.com> wrote: >> Postgres already allows != as a synonym for <>. I think having =! mean >> something subtly but significantly different is a terrible idea. At a >> minimum we would have to remove the synonym, which would be a backwards >> compatibility break. > I certainly agree with that. I do think, though, that IS DISTINCT FROM > is a terribly verbose thing to have to write all the time. It's not > that bad when you write a query that contains one instance of it, but > I've both seen and written queries where you need to use it a bunch of > times, and that can get really annoying.
How about instead of new operators we just provide a nice shorthand way of saying these? e.g. ARE and AINT :-) cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
