Hi,
i have a unique index on a table over multiple columns. If now one of the records has a null value in one of the indexed columns i can insert the same record multiple times.
Is this a problem within postgres or expected?
Example:
index unique, btree (colA, colB, colC);
would still allow me to insert
AAAA, ,CCCC AAAA, ,CCCC
Thanks for any help on that. A
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
