On Fri, 17 Jun 2016 10:56:32 +0200 Rapin Patrick <rapin.patr...@gmail.com> wrote:
> And my C++ wrapper then knows that this column is a speed expressed > in meters per second. So when making a SELECT on t1 table, the > wrapper will output number objects with unit dimension of Speed > expressed in m/s ! You are encoding type information in the name. If you move the type information into the data, SQLite can manage the unit dimension. You could use a CHECK constraint to require that speed was in m/s, or a trigger to make it so. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users