> There are some functions which are banned. Are extension functions permitted? And how does an extension function author indicate that the function is deterministic?
On Sun, Jun 10, 2018 at 10:23 AM, Simon Slavin <slav...@bigfraud.org> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
