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