From 80b3513d5700945447815e80a661c719d3e8f044 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 13 Feb 2003 05:26:50 +0000 Subject: The attached patch provides cube with 4 functions for building cubes directly from float8 values. (As opposed to converting the values to strings and then parsing the strings.) The functions are: cube(float8) returns cube cube(float8,float8) returns cube cube(cube,float8) returns cube cube(cube,float8,float8) returns cube Bruno Wolff III --- contrib/cube/sql/cube.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'contrib/cube/sql/cube.sql') diff --git a/contrib/cube/sql/cube.sql b/contrib/cube/sql/cube.sql index a0712c5557..d386a5a2f3 100644 --- a/contrib/cube/sql/cube.sql +++ b/contrib/cube/sql/cube.sql @@ -92,6 +92,24 @@ SELECT '1 e7'::cube AS cube; -- 6 SELECT '1,2a'::cube AS cube; -- 7 SELECT '1..2'::cube AS cube; -- 7 +-- +-- Testing building cubes from float8 values +-- + +SELECT cube(0::float8); +SELECT cube(1::float8); +SELECT cube(1,2); +SELECT cube(cube(1,2),3); +SELECT cube(cube(1,2),3,4); +SELECT cube(cube(cube(1,2),3,4),5); +SELECT cube(cube(cube(1,2),3,4),5,6); + +-- +-- Test that the text -> cube cast was installed. +-- + +SELECT '(0)'::text::cube; + -- -- Testing limit of CUBE_MAX_DIM dimensions check in cube_in. -- -- cgit v1.2.1