On 10 Jun 2018, at 1:09am, David Burgess <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
