[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] https://www.sqlite.org/draft/gencol.html Typo
From:       Darren Duncan <darren () darrenduncan ! net>
Date:       2019-10-30 5:30:50
Message-ID: dfaa1c5a-cd99-497e-8f16-551a2ac025b4 () darrenduncan ! net
[Download RAW message or body]

On 2019-10-29 6:20 a.m., Simon Slavin wrote:
>> • Every table must have at least one non-generated column.
> 
> I greatly admire this restriction.

 From a relational purist perspective that restriction is counter-productive.

But then, disallowing a table or a key/unique constraint from having exactly 
zero columns is likewise counter-productive and SQL already does that.

Allowing zero-column primary key constraints is the most elegant way to restrict 
a table to having not more than 1 row, useful for storing singleton data like 
some application configuration settings for example.

-- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]