How we can represent conditional indexing?

Ask the Community
1

How we can represent conditional indexing could you provide the syntax for

CREATE UNIQUE INDEX organisation_email ON “EmailConnections” USING btree (organisation_id, email_id) WHERE individual_id IS NULL AND organisation_id IS NOT NULL

2

Hi Ravi,

We don’t support conditional indexing syntax at the moment.

You can create a feature suggestion in DBML. We will consider implementing this syntax in the future.

Regards.