From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: =?UTF-8?B?6LCt5b+g5rab?= <zhongtao.tan@seaboxdata.com>,
        pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: The != and +/- signs are joined together as an operator
In-reply-to: 
 <CAKFQuwY4zVWKLp-94=t2Hcn91QdEGBm5h1s6tZW9xhU9Qxpo-g@mail.gmail.com>
References: <tencent_54FC93D9232417CD2384A569@qq.com>
 <CAKFQuwY4zVWKLp-94=t2Hcn91QdEGBm5h1s6tZW9xhU9Qxpo-g@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Wed, 19 Mar 2025 07:07:17 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <701030.1742394879.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 19 Mar 2025 10:34:39 -0400
Message-ID: <701031.1742394879@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/701031.1742394879%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, March 18, 2025, =E8=B0=AD=E5=BF=A0=E6=B6=9B <zhongtao.tan@se=
aboxdata.com> wrote:
>> select 1 !=3D-1;
>> select 1 !=3D+1;

> Explain why you think it is a bug.  From what I see those are potentiall=
y
> valid operator names that do not exist so =E2=80=9Coperator not found=E2=
=80=9D 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