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-482a2c7e3...@2ndquadrant.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/f50c80dbb17efa39c169f6c510e9464486ff5edc Modified Files -------------- contrib/cube/cube.c | 44 ++++++++-- contrib/cube/expected/cube.out | 168 ++++++++++++++++++++++++++++++++++++++- contrib/cube/expected/cube_2.out | 168 ++++++++++++++++++++++++++++++++++++++- contrib/cube/sql/cube.sql | 8 ++ doc/src/sgml/cube.sgml | 5 +- 5 files changed, 379 insertions(+), 14 deletions(-)
