Re: !<space>= should give error?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: !<space>= should give error?
Date: 2017-12-21 14:52:51
Message-ID: 20171221145251.rrum7zkthvdwaw52@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Todd A. Cook 2017-12-21 14:55:16 Re: force parallel mode vs CTAS
Previous Message Arthur Zakirov 2017-12-21 14:46:42 Re: [HACKERS] Flexible configuration for full-text search