llow negative coordinate for ~> (cube, int) operator
Teodor Sigaev <teodor@sigaev.ru>
llow negative coordinate for ~> (cube, int) operator ~> (cube, int) operator was especially designed for knn-gist search. However, knn-gist supports only ascending ordering of results. Nevertheless it would be useful to support descending ordering by ~> (cube, int) operator. We provide workaround for that: negative coordinate give us inversed value of corresponding cube bound. Therefore, knn search using negative coordinate gives us an effect of descending ordering by cube bound. Author: Alexander Korotkov Reviewed by: Tomas Vondra, Andrey Borodin Discussion: https://www.postgresql.org/message-id/flat/a9657f6a-b497-36ff-e56-482a2c7e3292@2ndquadrant.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/cube/cube.c | modified | +36 −8 |
| contrib/cube/expected/cube_2.out | modified | +166 −2 |
| contrib/cube/expected/cube.out | modified | +166 −2 |
| contrib/cube/sql/cube.sql | modified | +8 −0 |
| doc/src/sgml/cube.sgml | modified | +3 −2 |
Documentation touched
Discussion
Cited messages not in the archive:
a9657f6a-b497-36ff-e56-482a2c7e3292@2ndquadrant.com