SQLite Forum

STRICT tables and UNIQUE indices
Login
First thank you for this new table mode! It will be very helpful, especially the primary key mode which cannot not null anymore. 

What about unique indices and null. I know that Sqlite like to follow Postgresql but I already run into some bugs because of it. Maybe there could be some STRICT unique indices too which would only allow one null value in an index. Very often I work around it by defining some special value like -1 but sometimes this is not easy and using null as unique "non value" would be very helpful.

Thank you again for the STRICT tables. :-)

Marco