Functional Indexes
So working with PlanetScale and have a query that checks for LOWER(city) and LOWER(state) to handle user input. How can I use Drizzle-orm to create the composite functional index. I've tried a bunch of variations like the below but no luck.
stateCityIdx: index("state_city_idx").on(
sql
),
stateCityIdx: index("state_city_idx").on(
sql
(LOWER(${table.city}) LOWER(${table.state}))),
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
