I have this query :
SELECT SUM(median) FROM my_table WHERE id = 100
-- median is of type float4
When I run from psql, it returns slightly different result for multiple of runs (For example 1000.08, 1001.02, ...)
The number of entries contributing to the query is about 100K.
But when I run the query with SQL Editor of DBeaver (https://dbeaver.io/), I get same result consistently when I run multiple times.
Is there a way to configure psql so that I get same result as DBeaver ?