seifip · June 3, 2020 06:46
diff --git a/hasura-money-1.sql b/hasura-money-1.sql

 CREATE OR REPLACE FUNCTION test_float()
    RETURNS float AS $$
 DECLARE
    price float = 0.0;
 BEGIN
    WHILE price < 10.0 LOOP
        price = price + 0.1;
    END LOOP;
    RETURN price;
 END;
 $$ LANGUAGE plpgsql;
 SELECT test_float();

 --  test_float
 -- ---------------------
 --  10.09999999999998

	CREATE OR REPLACE FUNCTION test_float()
	RETURNS float AS $$
	DECLARE
	price float = 0.0;
	BEGIN
	WHILE price < 10.0 LOOP
	price = price + 0.1;
	END LOOP;
	RETURN price;
	END;
	$$ LANGUAGE plpgsql;
	SELECT test_float();

	-- test_float
	-- ---------------------
	-- 10.09999999999998