Unsigned integer, float postgres

postgres float a int

SELECT CAST(float_to_convert AS INTEGER) FROM your_table;
-- Or
SELECT float_to_convert::integer FROM your_table;