"paul schindler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > sqlite3_column_decltype("select amount from myvirtualtable", 0) > returns "INTEGER" -> good! > > BUT: > > sqlite3_column_decltype("select sum(amount) from myvirtualtable", 0) > returns NULL -> very bad!
What did you expect? Only column names have declared type. Expressions don't, whether they use aggregate functions or otherwise. > Is there a possibility to get the declared datatype of an aggregate > function? Aggregate function is not declared, so "declared datatype" is meaningless for it. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
