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

From Alvaro Herrera
Subject Re: != should give error?
Date
Msg-id 20171221145251.rrum7zkthvdwaw52@alvherre.pgsql
Whole thread Raw
In response to Re: != should give error?  (Mikael Kjellström <mikael.kjellstrom@mksoft.nu>)
Responses Re: != should give error?  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
List pgsql-hackers
Mikael Kjellström wrote:

> BTW isn't the "preferred" way of writing different from / not equal in SQL
> to use the <> operator?

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.

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


pgsql-hackers by date:

Previous
From: Arthur Zakirov
Date:
Subject: Re: [HACKERS] Flexible configuration for full-text search
Next
From: "Todd A. Cook"
Date:
Subject: Re: force parallel mode vs CTAS