SQLite Forum

sqlite3_column_type for a SUM column
Login
I am running a query that looks like:
```sql
select country, sum(population) as total_population
from cities
group by country
having total_population >= ?
order by total_population desc, country asc
```

I see `sqlite3_column_type()` returning ` SQLITE_NULL` for the `total_population` column. I can imagine how this happens, since it would require some data flow analysis to determine the actual type of the `sum()` expression; on the other hand, it is a bit of an annoyance because now that column comes back to me (on a NodeJS environment) as a string.

Is there a recommended way of getting the actual numeric value for this type of column? Should I just resign myself to try and manually convert them?

Cheers,
Gonzalo