Creating Unique Indexes, [w:] MSDN [online], Microsoft, wrzesień 2007 [dostęp 2012-08-27], Cytat: Handling NULL Values For indexing purposes, NULL values compare as equal. Therefore, a unique index, or UNIQUE constraint, cannot be created if the key values are NULL in more than one row. Select columns that are defined as NOT NULL when columns for a unique index or unique constraint are chosen.(ang.).
PostgreSQL 8.0.14 Documentation: Index Types [online], PostgreSQL [dostęp 2012-08-27], Cytat: B-trees can handle equality and range queries on data that can be sorted into some ordering. In particular, the PostgreSQL query planner will consider using a B-tree index whenever an indexed column is involved in a comparison using one of these operators: < ≤ = ≥ >
Constructs equivalent to combinations of these operators, such as BETWEEN and IN, can also be implemented with a B-tree index search. (But note that IS NULL is not equivalent to = and is not indexable.)(ang.).
PostgreSQL 8.0.14 Documentation: Unique Indexes [online], PostgreSQL [dostęp 2012-08-27], Cytat: When an index is declared unique, multiple table rows with equal indexed values will not be allowed. Null values are not considered equal. A multicolumn unique index will only reject cases where all of the indexed columns are equal in two rows.(ang.).
ChrisCh.DateChrisCh., Abstract: The Closed World Assumption [online], Data Management Association, San Francisco Bay Area Chapter [dostęp 2007-05-29] [zarchiwizowane z adresu 2007-05-19](ang.).
HughH.DarwenHughH., The Askew Wall [online] [dostęp 2012-09-04] [zarchiwizowane z adresu 2016-03-13](ang.).
ChrisCh.DateChrisCh., Abstract: The Closed World Assumption [online], Data Management Association, San Francisco Bay Area Chapter [dostęp 2007-05-29] [zarchiwizowane z adresu 2007-05-19](ang.).