On 9 Apr 2018, at 1:08am, Don V Nielsen <donvniel...@gmail.com> wrote:
> "For the purposes of unique indices, all NULL values are considered [to] > different from all other NULL values and are thus unique." > > I think it should read "...NULL value are considered different..." > > https://www.sqlite.org/lang_createindex.html I agree with Mister Nielsen that the original can be better phrased, but my English teacher would not forgive me if I did not suggest an even bigger change: "For the purposes of unique indices, all NULL values are considered to different from all other NULL values and are thus unique." should be "In unique indices, each NULL value is considered different to every other NULL value. Thus each NULL value is unique." Now my teacher is at peace, you may do what what you want. Since some edits are already being made to the page, one might as well suggest ... ------------- "Or if no collating sequence is otherwise defined, the built-in BINARY collating sequence is used." Should be "If no collating sequence is defined for a text column, the built-in BINARY collating sequence is used." ------------- "There are no arbitrary limits" should be more like "There is no arbitrary limit" though perhaps you might want to leave out the word 'arbitrary'. Or perhaps even leave out the entire sentence, since the spirit of SQLite is that limits to all entities are caused only by namespace exhaustion or memory/storage limits. ------------- "If the optional IF NOT EXISTS clause is present and another index with the same name already exists" Remove the word "optional" since the "if" makes it clear that the clause is optional. Replace "another" with "an". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
