Is there a way to declare a custom SQL index?

I'm trying to create an index on the lowercase value of a column using Postgres. I tried

unique().on(sql`lower(${table.username}::text)`)

unique().on(sql`lower(${table.username}::text)`)

but "on" only accepts columns

5 Replies

Piotrek•16mo ago

https://github.com/drizzle-team/drizzle-orm/blob/09d699f212ee3dc9d7ea3dbea1c56c4416604273/drizzle-orm/src/pg-core/unique-constraint.ts#L51 Looking at the source code, if only supports table columns

GitHub

drizzle-orm/drizzle-orm/src/pg-core/unique-constraint.ts at 09d699f...

TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

Andrii Sherman•16mo ago

not supported for now, but would be great if you can create GH feature request for that. Would gladly add a support for it

patrick•13mo ago

did this ever happen?

Paul•10mo ago

Any updates @Andrew Sherman , or can you tell us a way to hack this into the code so we don't have to manage some patch file?

Paul•10mo ago

https://github.com/drizzle-team/drizzle-orm/issues/1855

GitHub

[BUG]: .using() doesn't work in Postgres for add a lower() constrai...

What version of drizzle-orm are you using? 0.29.3 What version of drizzle-kit are you using? 0.20.14 Describe the Bug Trying to make a column case insensitive and unique using something like: expor...

Gaming

Programming

Is there a way to declare a custom SQL index?