Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Cutting off decimal zeroes #205
When working with numeric fields it is hard to visually compare values because Postico cuts off decimal zeroes so digits don't line up vertically.
select * from (values ('100.000'::numeric(10,3)), ('101.020'), ('90.542'), ('95.920')) measures(t) order by t;
PSQL does it right:
Fixed. Will be released in next update.
You can try it right now in the latest dev build: