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?
|
Список | 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 по дате отправления: