Postgres: how to excecute the query for Sum as it is giving error?

user_12182635 0
Viewed 2937

I am using sum function to find the total but getting error. Here is the query:

select sum(col1) 
from table_name 
where col2="abc"

Error: function sum(text) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts
postgresql
1 Answers

Assuming the text column contains text numbers, not actual integers, then it would explain the error you are seeing. You might get around this by first casting text to integer, then summing:

SELECT SUM(text::int)
FROM yourTable;
user_18632290
Related