Re: Named Operators

Поиск
Список
Период
Сортировка
От Matthias van de Meent
Тема Re: Named Operators
Дата
Msg-id CAEze2WjeYjcf-bm_4gggK7PQ+9fQQ6=hzGeYxTRY9r+D-BPt8g@mail.gmail.com
обсуждение исходный текст
Ответ на Named Operators  (Gurjeet Singh <gurjeet@singh.im>)
Ответы Re: Named Operators  (Gurjeet Singh <gurjeet@singh.im>)
Re: Named Operators  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Remove nonmeaningful prefixes in PgStat_* fields
Следующее
От: shveta malik
Дата:
Сообщение: Re: Time delayed LR (WAS Re: logical replication restrictions)