How to create indexes on expressions
I'm wanting to create a unique index with an expression to truncate a timestamp to minutes using postgresql's
date_trunc. I'm unsure how to go about doing this with the drizzle orm core utilities.
https://www.postgresql.org/docs/current/indexes-expressional.html
https://orm.drizzle.team/docs/indexes-constraints#indexesPostgreSQL Documentation
11.7. Indexes on Expressions
11.7. Indexes on Expressions # An index column need not be just a column of the underlying table, but can be …
Drizzle ORM - Indexes & Constraints
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
1 Reply
Ah this thread looks related
https://github.com/drizzle-team/drizzle-orm/issues/198 Seems not possible without modifying the generated migrations
https://github.com/drizzle-team/drizzle-orm/issues/198 Seems not possible without modifying the generated migrations