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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: 谭忠涛 <zhongtao(dot)tan(at)seaboxdata(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: The != and +/- signs are joined together as an operator
Date: 2025-03-19 14:34:39
Message-ID: 701031.1742394879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tuesday, March 18, 2025, 谭忠涛 <zhongtao(dot)tan(at)seaboxdata(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-03-19 15:45:20 Re: Possible bug acldefault function
Previous Message David G. Johnston 2025-03-19 14:07:17 Re: The != and +/- signs are joined together as an operator