Celé číslo bez znaménka float postgres

postgres float na int

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