Re: != should give error?

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