pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: 谭忠涛 <zhongtao.tan@seaboxdata.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: The != and +/- signs are joined together as an operator
Date: Wed, 19 Mar 2025 10:34:39 -0400
Message-ID: <701031.1742394879@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwY4zVWKLp-94=t2Hcn91QdEGBm5h1s6tZW9xhU9Qxpo-g@mail.gmail.com>
References: <tencent_54FC93D9232417CD2384A569@qq.com>
	<CAKFQuwY4zVWKLp-94=t2Hcn91QdEGBm5h1s6tZW9xhU9Qxpo-g@mail.gmail.com>

"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





view thread (3+ messages)

Message-ID: <701031.1742394879@sss.pgh.pa.us>
Permalink:  ../701031.1742394879@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/701031.1742394879@sss.pgh.pa.us

 · 

reply
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: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, zhongtao.tan@seaboxdata.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: The != and +/- signs are joined together as an operator
  In-Reply-To: <701031.1742394879@sss.pgh.pa.us>

* 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