Unique statements with `WHERE`

How would i go about creating the following in drizzle? I have tried a few different ways and apparently im missing something
CREATE UNIQUE INDEX uq_tags_public_name
ON tags ((lower(name))) WHERE scope='PUBLIC';
CREATE UNIQUE INDEX uq_tags_public_name
ON tags ((lower(name))) WHERE scope='PUBLIC';
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?