]> granicus.if.org Git - postgresql/commit
llow negative coordinate for ~> (cube, int) operator
authorTeodor Sigaev <teodor@sigaev.ru>
Thu, 11 Jan 2018 11:49:36 +0000 (14:49 +0300)
committerTeodor Sigaev <teodor@sigaev.ru>
Thu, 11 Jan 2018 11:49:36 +0000 (14:49 +0300)
commitf50c80dbb17efa39c169f6c510e9464486ff5edc
tree28bd442434d2c59b6f2662e600440a4a30c4374a
parent563a053bdd4b91c5e5560f4bf91220e562326f7d
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
contrib/cube/cube.c
contrib/cube/expected/cube.out
contrib/cube/expected/cube_2.out
contrib/cube/sql/cube.sql
doc/src/sgml/cube.sgml