Re: != should give error? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: != should give error?
Date
Msg-id 20171221154233.6ofcaah3sk5uctck@alvherre.pgsql
Whole thread Raw
In response to Re: != should give error?  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
List pgsql-hackers
Dagfinn Ilmari Mannsåker wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:

> > Yes, <> is the operator mandated by the SQL standard.  I don't think !=
> > appears anywhere -- it's our extension only and thus if you use it you
> > should not expect your applications to work on other DBMSs.

> So while it might not be standard SQL, it's definitely not "our
> extension only".

Well, that means everybody else also extends, but since it's not
standard, the operator could mean something different and if your app
breaks because of that, you get to keep the pieces.

As in some other thread, "we're in {good company, bad society}" in this
regard.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Date:
Subject: Re: != should give error?
Next
From: Robert Haas
Date:
Subject: Re: force parallel mode vs CTAS