DT

Drizzle Team•2y ago•

1 reply

node

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

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#indexes

PostgreSQL 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.