On Sun, 2 Apr 2017 23:50:01 +1000 David Burgess <[email protected]> wrote:
> The rules for the format of these numbers has changed over time and > the schema has changed with the rules of the time. PRAGMA > integrity_check now complains about some rows not passing the > constraint. No one suggested the obvious solution: modify the CHECK constraint to describe the allowed values in the column. With a little cleverness, perhaps the constraint could prevent use of the old form for new rows, too. --jkl _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
