Comparing SQLite numeric with Decimal
Hello, quick beginner question: How am I supposed to compare an SQLite column with data type
numeric with a decimal JS number? The numeric is read as a string, so shall I cast the decimal to string, like this https://github.com/drizzle-team/drizzle-orm/issues/570#issuecomment-1549158181 ?
I guess that comparing decimal numbers as strings will not work properly ...GitHub
[BUG]: numeric types returning type string with postgres · Issue #...
What version of drizzle-orm are you using? 0.25.3 What version of drizzle-kit are you using? 0.17.6 Describe the Bug export const order = pgTable( 'orders', { ... totalValue: numeric('t...
1 Reply
The drizzle docs do not say anything 😅 https://orm.drizzle.team/docs/column-types/sqlite#numeric
Drizzle ORM - SQLite column types
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.