On 10/29/19, Keith Medcalf <[email protected]> wrote: > > Before you change anything, I think that is incorrect for the various > datetime functions. I think they SHOULD be permitted in CHECK constraints > and in generated always columns, whether those are stored or virtual, > whether or not parameters are given since they are constant. They should > not be permitted in indexes however unless they are pure (deterministic).
i believe the purpose of a CHECK constraint is declare an eternal truth about the database content, not merely something that was true at the point in time when the content was first inserted. Am I wrong? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
