Igor Tandetnik wrote:
>
> "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
>
>
Thanks for your answer,
So is there no possibility to get the underlying declared datatype? e.g.
when amount is declared INTEGER then every aggregate function on amount
(sum, max, min...) also has to be an INTEGER.
Paul
--
View this message in context:
http://www.nabble.com/Get-declared-Datatype-of-SQLite-Virtual-Table-tp19330789p19366611.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
