On Thu, Jan 26, 2017 at 5:04 PM, David Raymond <david.raym...@tomtom.com> wrote:
> Other thing to point out is that constants/(expressions that aren't coming > from a field in a table) have "no affinity", so explicitly typing '25' is a > no affinity, not a text affinity, and 25 is no affinity, not integer > affinity. (Section 4.2 in the page linked by DRH) > And countless SQLite users must be bitten by this everyday! :) Could we have a affinityof() built-in function similar to typeof()? That would go a long way to understanding SQLite's peculiar type system via self experimentation IMHO. Thanks, --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
