On 10 Jun 2018, at 1:09am, David Burgess <dburges...@gmail.com> wrote:

> full_account_number AS ( branch || account_number )
> or
> branch AS (substr(full_account_number,1,4)),
> account_number AS (substr(full_account_number,5))

All the above are allowed in computed columns.  There are some functions which 
are banned.  They are mostly non-deterministic functions.  So a calculation 
which depends on 'now' would not be allowed.  Similarly for COUNT(*) or the 
result of a PRAGMA.

sqlite-users mailing list

Reply via email to