DROP TABLE precision_test;
DROP TABLE precision_test2;

CREATE TABLE precision_test
(
  foo real
);

INSERT INTO precision_test
  SELECT 20.20
UNION SELECT 1969.22;

CREATE TABLE precision_test2
(
  foo double precision
);

INSERT INTO precision_test2 (foo) SELECT foo from precision_test;


SELECT * FROM precision_test;
SELECT * FROM precision_test2;