1

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 ?

Philippe
  • 220

0 Answers0