CODEWITHSUNDEEP
amazon-web-servicesamazon-redshift
Ganesh
Ganesh

Reputation: 3

Redshift sum and round function discrepancy

Applied sum and round function some of the values not generated properly in Redshift.

round((field1+field2),1)

Upvotes: 0

Views: 633

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269151

When strange results come from an SQL query, it is possible that your SQL client is rounding the values displayed on-screen.

To check this, convert numbers to text to show their real value in the database, preventing them from being modified by your SQL client.

For example:

SELECT a, a::TEXT, b, b::TEXT

Upvotes: 2

Related Questions