On Dec 15, 2009, at 10:53 AM, Cariotoglou Mike wrote:
> Quoting from the documentation on Type Affinity:
>
By coincidence, I was working on rewriting and clarifying that
documentation just last night. The latest draft can be seen at
http://www.sqlite.org/draft/datatype3.html
My belief is that the new document text says exactly the same thing as
the old, though perhaps more compactly and clearly.
> since, in the examples posted, (select count(*) from ...) should be an
> expression, and since it is compared to a value, it should take on the
> affinity
> of the value, no ? AH, GOT IT. values do NOT have affinity. so I would
> either need to cast the expression OR the value.
Yes.
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
