Small. Fast. Reliable.
Choose any three.

create-index-stmt

CREATE UNIQUE INDEX IF NOT EXISTS schema-name . index-name ON table-name ( indexed-column ) , WHERE expr

Used by:   sql-stmt

References:   expr   indexed-column

See also:   lang_createindex.html   partialindex.html