New posts in Partial Index

Partial Index not used in ON CONFLICT clause while performing an upsert in Postgresql

Workaround in mysql for partial Index or filtered Index?