Re: Named Operators - Mailing list pgsql-hackers

From Matthias van de Meent
Subject Re: Named Operators
Date
Msg-id CAEze2WjeYjcf-bm_4gggK7PQ+9fQQ6=hzGeYxTRY9r+D-BPt8g@mail.gmail.com
Whole thread Raw
In response to Named Operators  (Gurjeet Singh <gurjeet@singh.im>)
Responses Re: Named Operators
Re: Named Operators
List pgsql-hackers
On Thu, 12 Jan 2023 at 10:16, Gurjeet Singh <gurjeet@singh.im> wrote:
>
> Technically correct name of this feature would be Readable Names for
> Operators, or Pronounceable Names for Operators. But I'd like to call
> it Named Operators.
>
> With this patch in place, the users can name the operators as
> :some_pronounceable_name: instead of having to choose from the special
> characters like #^&@.
> [...]
>     I think Named Operators will significantly improve the readability
> of queries.

Couldn't the user better opt to call the functions that implement the
operator directly if they want more legible operations? So, from your
example, `SELECT box_add(a, b)` instead of `SELECT a :add_point: b`?

I'm -1 on the chosen syntax; :name: shadows common variable
substitution patterns including those of psql.

Kind regards,

Matthias van de Meent



pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Remove nonmeaningful prefixes in PgStat_* fields
Next
From: shveta malik
Date:
Subject: Re: Time delayed LR (WAS Re: logical replication restrictions)