Re: Okay to remove mention of mystery @ and ~ operators?

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: Okay to remove mention of mystery @ and ~ operators?
Дата
Msg-id CAJ7c6TOhz5EwmtJ70_Fo++H0_uxUfkmRfE9O=f3q2Xpkhx+5uw@mail.gmail.com
обсуждение исходный текст
Ответ на Okay to remove mention of mystery @ and ~ operators?  (Colin Caine <cmcaine@gmail.com>)
Ответы Re: Okay to remove mention of mystery @ and ~ operators?  (Aleksander Alekseev <aleksander@timescale.com>)
Список pgsql-hackers
Hi,

> This page says that the `@` and `~` operators on various types can be accelerated by a GiST index.
>
> https://www.postgresql.org/docs/current/gist-builtin-opclasses.html
>
> These operators have been listed in the file since it was created in 2014, but if they exist then I don't know how to
usethem or what they do.
 
>
> Code examples, for clarity:
>
> > select box '(0,0),(1, 1)' ~ box '(2,2),(3,3)';
> operator does not exist: box ~ box
>
> > select box '(0,0),(1, 1)' @ box '(2,2),(3,3)';
> operator does not exist: box @ box
>
> If they're a typo or some removed thing then I'd like to remove them from the page. This email is me asking to find
outif I'm wrong about that before I try to submit a patch (also very happy for someone with a committer bit to just fix
this).

Indeed, there is no @(box,box) or ~(box,box) in the \dAo output. These
operators were removed by 2f70fdb0644c back in 2020.

I will submit a patch for the documentation shortly. Thanks for reporting.

-- 
Best regards,
Aleksander Alekseev



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Aleksander Alekseev
Дата:
Сообщение: Re: [PATCH] Replace magic constant 3 with NUM_MERGE_MATCH_KINDS
Следующее
От: shveta malik
Дата:
Сообщение: Re: Disallow changing slot's failover option in transaction block