On Sun, 2 Apr 2017 23:50:01 +1000 David Burgess <dburg...@gmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
