January 10th, 2016 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.6 – Cube extension kNN support

On 18th of December, Teodor Sigaev committed patch: Introduce distance operators over cubes: < #> taxicab distance < -> euclidean distance < => chebyshev distance Also add kNN support of those distances in GiST opclass. Author: Stas Kelvich

On 16th of May, Andres Freund committed patch: Support GROUPING SETS, CUBE and ROLLUP. This SQL standard functionality allows to aggregate data by different GROUP BY clauses at once. Each grouping set returns rows with columns grouped by in other sets set to NULL. This ...