Re: Reverse btree indexes

2021-06-22 Thread David G. Johnston
On Tue, Jun 22, 2021 at 2:28 PM Zach Aysan wrote: > *Desired improvement:* > > for example, col LIKE 'foo%' or col ~ '^foo', but not col LIKE '%bar', >> which would require a reversed index on the field. Postgres will >> automatically use the reverse index for LIKE '%bar' > > > *Or if it doesn't

Reverse btree indexes

2021-06-22 Thread Zach Aysan
Hey there! Thanks for putting together such wonderful documentation. I have a small suggestion for improvement. *Page:* https://www.postgresql.org/docs/13/indexes-types.html *Existing language:* for example, col LIKE 'foo%' or col ~ '^foo', but not col LIKE '%bar'. *Desired improvement:* for

Operator function clarification needed

2021-06-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/gin-builtin-opclasses.html Description: https://www.postgresql.org/docs/12/gin-builtin-opclasses.html It is unclear what the operators do. Page should link to relevant section(s) of docum