> 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 <[email protected]> wrote: > 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
