On 10/28/19 8:37 AM, Robert Haas wrote:
> On Mon, Oct 28, 2019 at 7:54 AM Isaac Morland <isaac.morland@gmail.com> wrote:
>> Postgres already allows != as a synonym for <>. I think having =! mean something subtly but significantly different
isa 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
