Rohanisburg
DTDrizzle Team
•Created by Rohanisburg on 8/13/2024 in #help
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
(LOWER(${table.city}) LOWER(${table.state})),
),1 replies