CREATE EXTENSION floatfile; SELECT save_floatfile('test', '{1,2,3,NULL,4,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT load_floatfile('test'); load_floatfile --------------------- {1,2,3,NULL,4,NULL} (1 row) SELECT extend_floatfile('test', '{NULL,5}'::float[]); extend_floatfile ------------------ (1 row) SELECT load_floatfile('test'); load_floatfile ---------------------------- {1,2,3,NULL,4,NULL,NULL,5} (1 row) SELECT drop_floatfile('test'); drop_floatfile ---------------- (1 row) -- Can't overwrite a file without removing it first: SELECT save_floatfile('newtest', '{7,7,7}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('newtest', '{7,7,7}'::float[]); ERROR: Failed to save floatfile newtest: File exists SELECT load_floatfile('newtest'); load_floatfile ---------------- {7,7,7} (1 row) SELECT drop_floatfile('newtest'); drop_floatfile ---------------- (1 row) -- Appending creates the file if necessary: SELECT extend_floatfile('newtest', '{NULL,5}'::float[]); extend_floatfile ------------------ (1 row) SELECT load_floatfile('newtest'); load_floatfile ---------------- {NULL,5} (1 row) SELECT drop_floatfile('newtest'); drop_floatfile ---------------- (1 row) -- Tablespace tests: DROP TABLESPACE IF EXISTS testspace; NOTICE: tablespace "testspace" does not exist, skipping \! test -d /tmp/testspace || echo "* * * Can't test tablespaces unless you mkdir /tmp/testspace and chown it to the postgres user * * *" CREATE TABLESPACE testspace LOCATION '/tmp/testspace'; SELECT save_floatfile('testspace', 'test', '{1,2,3,NULL,4,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT load_floatfile('testspace', 'test'); load_floatfile --------------------- {1,2,3,NULL,4,NULL} (1 row) SELECT extend_floatfile('testspace', 'test', '{NULL,5}'::float[]); extend_floatfile ------------------ (1 row) SELECT load_floatfile('testspace', 'test'); load_floatfile ---------------------------- {1,2,3,NULL,4,NULL,NULL,5} (1 row) SELECT drop_floatfile('testspace', 'test'); drop_floatfile ---------------- (1 row) DROP TABLESPACE testspace; -- Tests about releasing advisory locks: SELECT classid, objid FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) AND locktype = 'advisory'; classid | objid ---------+------- (0 rows) SELECT load_floatfile('nofile'); ERROR: Failed to load floatfile nofile: No such file or directory SELECT classid, objid FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) AND locktype = 'advisory'; classid | objid ---------+------- (0 rows) SELECT save_floatfile('nofile', '{1,2,3}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('nofile', '{1,2,3}'::float[]); ERROR: Failed to save floatfile nofile: File exists SELECT classid, objid FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) AND locktype = 'advisory'; classid | objid ---------+------- (0 rows) SELECT drop_floatfile('nofile'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('nofile'); ERROR: Failed to delete floatfile nofile: No such file or directory SELECT classid, objid FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) AND locktype = 'advisory'; classid | objid ---------+------- (0 rows) -- Histogram tests: SELECT save_floatfile('a', '{1,1,1,1,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('a', 0::float, 1::float, 5); floatfile_to_hist ------------------- {0,4,0,0,0} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10); floatfile_to_hist ----------------------- {0,0,0,0,2,0,0,0,0,0} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) -- Histogram with bounds tests: SELECT save_floatfile('t', '{1,2,3,NULL,4,5}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1,1,1,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('a', 0::float, 1::float, 5, 't', 2::float, 5::float); floatfile_to_hist ------------------- {0,4,0,0,0} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1,1.2,1.2,1.8,1.8}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 1::float, 5::float); floatfile_to_hist ----------------------- {0,0,0,0,2,2,0,0,2,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 2::float, 5::float); floatfile_to_hist ----------------------- {0,0,0,0,1,2,0,0,2,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 1::float, 4::float); floatfile_to_hist ----------------------- {0,0,0,0,2,2,0,0,1,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 2::float, 4::float); floatfile_to_hist ----------------------- {0,0,0,0,1,2,0,0,1,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 2.2::float, 2.4::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', 7::float, 8::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT floatfile_to_hist('a', -0.115::float, 0.23::float, 10, 't', -3::float, -2::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('t'); drop_floatfile ---------------- (1 row) -- Histogram with tablespace tests: CREATE TABLESPACE testspace LOCATION '/tmp/testspace'; SELECT save_floatfile('testspace', 'a', '{1,1,1,1,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('testspace', 'a', 0::float, 1::float, 5); floatfile_to_hist ------------------- {0,4,0,0,0} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10); floatfile_to_hist ----------------------- {0,0,0,0,2,0,0,0,0,0} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT save_floatfile(NULL, 'a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist(NULL, 'a', -0.115::float, 0.23::float, 10); floatfile_to_hist ----------------------- {0,0,0,0,2,0,0,0,0,0} (1 row) SELECT drop_floatfile(NULL, 'a'); drop_floatfile ---------------- (1 row) DROP TABLESPACE testspace; -- Histogram with tablespace and bounds tests: CREATE TABLESPACE testspace LOCATION '/tmp/testspace'; SELECT save_floatfile('testspace', 't', '{1,2,3,NULL,4,5}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1,1,1,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('testspace', 'a', 0::float, 1::float, 5, 'testspace', 't', 2::float, 5::float); floatfile_to_hist ------------------- {0,4,0,0,0} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1,1.2,1.2,1.8,1.8}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 1::float, 5::float); floatfile_to_hist ----------------------- {0,0,0,0,2,2,0,0,2,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 2::float, 5::float); floatfile_to_hist ----------------------- {0,0,0,0,1,2,0,0,2,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 1::float, 4::float); floatfile_to_hist ----------------------- {0,0,0,0,2,2,0,0,1,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 2::float, 4::float); floatfile_to_hist ----------------------- {0,0,0,0,1,2,0,0,1,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 2.2::float, 2.4::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', 7::float, 8::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT floatfile_to_hist('testspace', 'a', -0.115::float, 0.23::float, 10, 'testspace', 't', -3::float, -2::float); floatfile_to_hist ----------------------- {0,0,0,0,0,0,0,0,0,0} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 't'); drop_floatfile ---------------- (1 row) DROP TABLESPACE testspace; -- 2D Histogram tests: SELECT save_floatfile('a', '{1,1,1,1,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('b', '{1,1,0,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('a', 'b', 0::float, 0::float, 1::float, 1::float, 5, 2); floatfile_to_hist2d --------------------------------- {{0,0},{1,2},{0,0},{0,0},{0,0}} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('b'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('b', '{1,2}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('b'); drop_floatfile ---------------- (1 row) -- 2D Histogram with bounds tests: SELECT save_floatfile('t', '{1,2,3,NULL,4,5}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1,1,1,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('b', '{1,1,0,NULL,1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('a', 'b', 0::float, 0::float, 1::float, 1::float, 5, 2, 't', 2::float, 5::float); floatfile_to_hist2d --------------------------------- {{0,0},{1,2},{0,0},{0,0},{0,0}} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('b'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('a', '{1,1,1.2,1.2,1.8,1.8}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('b', '{1,1,1,2,2,2}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 1::float, 5::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{2,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,2},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 2::float, 5::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,2},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 1::float, 4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{2,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 2::float, 4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 2.2::float, 2.4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', 7::float, 8::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('a', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 't', -3::float, -2::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT drop_floatfile('a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('b'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('t'); drop_floatfile ---------------- (1 row) -- 2D histogram with tablespace tests: CREATE TABLESPACE testspace LOCATION '/tmp/testspace'; SELECT save_floatfile('testspace', 'a', '{1,1,1,1,NULL}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'b', '{1,1,0,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', 0::float, 0::float, 1::float, 1::float, 5, 2); floatfile_to_hist2d --------------------------------- {{0,0},{1,2},{0,0},{0,0},{0,0}} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 'b'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'b', '{1,2}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 'b'); drop_floatfile ---------------- (1 row) SELECT save_floatfile(NULL, 'a', '{1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile(NULL, 'b', '{1,2}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d(NULL, 'a', NULL, 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT drop_floatfile(NULL, 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile(NULL, 'b'); drop_floatfile ---------------- (1 row) DROP TABLESPACE testspace; -- 2D Histogram with tablespace and bounds tests: CREATE TABLESPACE testspace LOCATION '/tmp/testspace'; SELECT save_floatfile('testspace', 't', '{1,2,3,NULL,4,5}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1,1,1,NULL,1}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'b', '{1,1,0,NULL,1,1}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', 0::float, 0::float, 1::float, 1::float, 5, 2, 'testspace', 't', 2::float, 5::float); floatfile_to_hist2d --------------------------------- {{0,0},{1,2},{0,0},{0,0},{0,0}} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 'b'); drop_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'a', '{1,1,1.2,1.2,1.8,1.8}'::float[]); save_floatfile ---------------- (1 row) SELECT save_floatfile('testspace', 'b', '{1,1,1,2,2,2}'::float[]); save_floatfile ---------------- (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 1::float, 5::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{2,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,2},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 2::float, 5::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,2},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 1::float, 4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{2,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 2::float, 4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,0},{1,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,1},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 2.2::float, 2.4::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', 7::float, 8::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT floatfile_to_hist2d('testspace', 'a', 'testspace', 'b', -0.115::float, 0.944444::float, 0.23::float, 0.111111::float, 10, 10, 'testspace', 't', -3::float, -2::float); floatfile_to_hist2d ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0},{0,0,0,0,0,0,0,0,0,0}} (1 row) SELECT drop_floatfile('testspace', 'a'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 'b'); drop_floatfile ---------------- (1 row) SELECT drop_floatfile('testspace', 't'); drop_floatfile ---------------- (1 row) DROP TABLESPACE testspace;