From: 谭忠涛 <zhongtao.tan@seaboxdata.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: 回复：Re: The != and +/- signs are joined together as an operator
Date: Thu, 20 Mar 2025 09:11:33 +0800
Message-ID: <tencent_66B9FBC77B1326A007855EB1@qq.com> (raw)
But "!=" is not the same as "<>"
1!=-1, "!=-" as a whole is treated as an operator, not as an operator "!=" -1, but in 1<>-1, it is treated as "<>" -1 instead of "<>-" as a whole is treated as an operator
I think "!=" and "<>" should be treated in the same way
Regards
Tom Lane<tgl@sss.pgh.pa.us> 在 2025年3月19日 周三 22:34 写道：
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: zhongtao.tan@seaboxdata.com, tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: 回复：Re: The != and +/- signs are joined together as an operator
In-Reply-To: <tencent_66B9FBC77B1326A007855EB1@qq.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox