On 1/12/20 5:25 PM, Tom Browder wrote:
On Sun, Jan 12, 2020 at 14:05 Keith Medcalf <kmedc...@dessus.com> wrote:
On Sunday, 12 January, 2020 09:03, Tom Browder <tom.brow...@gmail.com>
wrote:
Am I missing something? I thought every column has to have a type?
Close, but no banana. Every value has a type. A column may contain
multiple values (as in one per row)....
Thanks, Keith.
I assume that is just for SQLite, or am I wrong again?
-Tom
That the entries for a given column in different rows can have different
types is a peculiarity of SQLite. In a 'Standard' SQL database, a column
has a defined type, and all rows will have values of that type (or NULL).
--
Richard Damon
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
