Re: Named Operators - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Named Operators
Date
Msg-id 1097504.1673543640@sss.pgh.pa.us
Whole thread Raw
In response to Re: Named Operators  (Isaac Morland <isaac.morland@gmail.com>)
Responses Re: Named Operators
Re: Named Operators
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Remove nonmeaningful prefixes in PgStat_* fields
Next
From: Peter Eisentraut
Date:
Subject: Re: Refactor recordExtObjInitPriv()