News for hackers. Stuff that matters.
Re:Why favor PostgreSQL over MariaDB/MySQL? by Mouse47 on Tuesday September 05, 2017 @02:03PM (#15177619)
>CREATE UNIQUE INDEX (filtered)

Ha...that's a bit of a hack! I've had to do a similar trick for a unique constraint on columns where we didn't care if the value was null. SQL Server (for some reason) considers null a value in this case; in other words, there could only be one null value in the table for purposes of a unique constraint.

E.g:

    create unique index on (col) where col is not null
Re:Why favor PostgreSQL over MariaDB/MySQL? by snuxoll on Tuesday September 05, 2017 @02:58PM (#15178110)
Stuff like this always makes me glad PostgreSQL takes adherence to the SQL standard seriously, NULLS are supposed to be considered non-equal for unique indexes - probably some stupid design from the Sybase days that MS decided was easier to keep for compatibility than change, though.