Re: The != and +/- signs are joined together as an operator

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: 谭忠涛 <zhongtao.tan@seaboxdata.com>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2025-03-19T14:34:39Z
Lists: pgsql-bugs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, March 18, 2025, 谭忠涛 <zhongtao.tan@seaboxdata.com> wrote:
>> select 1 !=-1;
>> select 1 !=+1;

> Explain why you think it is a bug.  From what I see those are potentially
> valid operator names that do not exist so “operator not found” is the
> correct outcome.

Our rules for operator names are here:

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS

			regards, tom lane