Re: [sqlite] Confusing FAQ(26) wording

2009-12-31 Thread Tobias Hoffmann
> > http://www.sqlite.org/nulls.html > > seems to clarify things for me on this topic. > That definitely helps. Perhaps someone could add this link in the FAQ(26)? Thanks Pavel and Adam. Tobias ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Confusing FAQ(26) wording

2009-12-30 Thread Pavel Ivanov
To be honest I'm a bit confused about the wording of these two bullets too. But here're my comments and clarifications: >>     Perhaps you are referring to the following statement from SQL92: >> >>         A unique constraint is satisfied if and only if no two rows in >>         a table have the

Re: [sqlite] Confusing FAQ(26) wording

2009-12-30 Thread Adam DeVita
http://www.sqlite.org/nulls.html seems to clarify things for me on this topic. Adam On Wed, Dec 30, 2009 at 9:13 AM, Tobias Hoffmann < lsqlite-l...@thax.hardliners.org> wrote: > Hi, > > I had a hard time to understand the FAQ entry on UNIQUE constraint -- in > the end I had to try out sqlite's

[sqlite] Confusing FAQ(26) wording

2009-12-30 Thread Tobias Hoffmann
Hi, I had a hard time to understand the FAQ entry on UNIQUE constraint -- in the end I had to try out sqlite's behavior myself because the FAQ -- so maybe the wording can be improved and/or an example added. Here a some comments: > *(26) The SQL standard requires that a UNIQUE constraint be