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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users