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

From Tom Lane
Subject Re: The != and +/- signs are joined together as an operator
Date
Msg-id 701031.1742394879@sss.pgh.pa.us
Whole thread Raw
In response to Re: The != and +/- signs are joined together as an operator  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: The != and +/- signs are joined together as an operator
Next
From: Tom Lane
Date:
Subject: Re: Possible bug acldefault function