"ed" <epdm...@gmail.com> wrote in message news:d92e64410905221106t5c8b77eay9cbc5a4e3ccb8...@mail.gmail.com > I guess i was assuming the command "create table x as select * from y" > should preserve column constraints
Well, it can't, in general. Nothing says that a column in the newly created table must correspond to a column in existing table. Consider: create table x as select 1, a, b+1, c+d from y; What constraints should be placed on the four columns of table x, and why? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
