Database Reference
In-Depth Information
•
cube_distance
: This checks the distance between two cubes. This can be
explained using the following example:
warehouse_db=# SELECT cube_distance(cube(5,5),
cube(10,10));
cube_distance
---------------
5
(1 row)
•
cube_subset
: This is used to makes a new cube from an existing cube.
This can be explained using the following example:
warehouse_db=# SELECT cube_subset(cube(5,5), ARRAY[1,1]);
cube_subset
-------------
(5, 5)
(1 row)
•
cube_union
: This is used for the union of two cubes. This can be explained
using the following example:
warehouse_db=# SELECT cube_union(cube(5,5), cube(10,10));
cube_union
------------
(5),(10)
(1 row)
•
cube_inter
: This is used for the intersection of two cubes. This can be
explained using the following example:
warehouse_db=# SELECT cube_inter(cube(5,5), cube(10,10));
cube_inter
------------
(10),(5)
(1 row)
•
cube_enlarge
: This is used to increase the size of the cube. This can be
explained using the following example:
warehouse_db=# SELECT cube_enlarge(cube(5,5), 5, 5);
cube_enlarge
--------------------------------------
(0, -5, -5, -5, -5),(10, 5, 5, 5, 5)
(1 row)
