From: Tom Lane <tgl@sss.pgh.pa.us>
To: Isaac Morland <isaac.morland@gmail.com>
cc: Gurjeet Singh <gurjeet@singh.im>,
        Matthias van de Meent <boekewurm+postgres@gmail.com>,
        Postgres Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Named Operators
In-reply-to: <CAMsGm5d3mBF=PQiHKV0ptXNiMW34aZ3u=44ams7ObWbZYfsRLQ@mail.gmail.com>
References: <CABwTF4VVuacLV+coERacdDxUXg5tDMHZxvgH5+ek0UZvoq386g@mail.gmail.com> <CAEze2WjeYjcf-bm_4gggK7PQ+9fQQ6=hzGeYxTRY9r+D-BPt8g@mail.gmail.com> <CABwTF4Uh3FUK6_9mj_aszciLt-CU0eYKiCdaL1nXShjxaHhbqQ@mail.gmail.com> <CAMsGm5d3mBF=PQiHKV0ptXNiMW34aZ3u=44ams7ObWbZYfsRLQ@mail.gmail.com>
Comments: In-reply-to Isaac Morland <isaac.morland@gmail.com>
	message dated "Thu, 12 Jan 2023 12:02:37 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1097503.1673543640.1@sss.pgh.pa.us>
Date: Thu, 12 Jan 2023 12:14:00 -0500
Message-ID: <1097504.1673543640@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1097504.1673543640%40sss.pgh.pa.us>
Precedence: bulk

Isaac Morland <isaac.morland@gmail.com> writes:
> What about backticks (`)? They are allowed as operator characters but do
> not otherwise appear in the lexical syntax as far as I can tell:
> https://www.postgresql.org/docs/current/sql-syntax-lexical.html

Since they're already allowed as operator characters, you can't
use them for this purpose without breaking existing use-cases.

Even if they were completely unused, I'd be pretty hesitant to
adopt them for this purpose because of the potential confusion
for users coming from mysql.

Pretty much the only available syntax space is curly braces,
and I don't really want to give those up for this either.
(One has to assume that the SQL committee has their eyes
on those too.)

			regards, tom lane