| From: | Colin Caine <cmcaine(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Okay to remove mention of mystery @ and ~ operators? |
| Date: | 2024-04-19 03:41:41 |
| Message-ID: | CADwQTQbbr2UQ_fpbyc+8ay=RwEYgYk=TZxH3+RHDqAQfoG+EWA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
This page says that the `(at)` 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 use them 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 out if 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).
Cheers,
Col
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton A. Melnikov | 2024-04-19 03:50:39 | Use XLOG_CONTROL_FILE macro everywhere? |
| Previous Message | Andres Freund | 2024-04-19 03:40:22 | Re: ECPG cleanup and fix for clang compile-time problem |