On 10 Jun 2018, at 2:00am, Andy Goth <andrew.m.g...@gmail.com> wrote:
> CREATE TABLE tempLog (
> datestamp TEXT COLLATE NOCASE PRIMARY KEY
> , centTemp REAL);
> CREATE VIEW tempLogView AS
> SELECT *
> , centTemp * 9 / 5 + 32 AS fahrTemp
> FROM tempLog;
Yes. That is an elegant and compact way to do it with SQLite as it is now.
But it's not as satisfying. And it doesn't allow indexing by the computed
column. You have to define the calculation in the index separately.
sqlite-users mailing list