Numeric type returns number instead of string as defined in TypeScript

Hello, I'm trying Drizzle ORM with PostgreSQL and TypeScript. I've noticed a discrepancy between the TypeScript definitions and the actual runtime behavior for numeric fields.

Schema definition:

export const bankrolls = pgTable('bankrolls', {
  id: uuid('id').primaryKey(),
  name: varchar('name'),
  startingCapital: numeric('starting_capital', { precision: 8, scale: 2 }),
});

export const bankrolls = pgTable('bankrolls', {
  id: uuid('id').primaryKey(),
  name: varchar('name'),
  startingCapital: numeric('starting_capital', { precision: 8, scale: 2 }),
});

The request

async all(userId: string): Promise<BankrollsViewModel[]> {
  const result = await this.sqlConnection
    .select()
    .from(bankrolls)
    .where(eq(bankrolls.userId, userId));
  return result;
}

async all(userId: string): Promise<BankrollsViewModel[]> {
  const result = await this.sqlConnection
    .select()
    .from(bankrolls)
    .where(eq(bankrolls.userId, userId));
  return result;
}

The type of result is inferred as:

{
  id: string;
  name: string;
  startingCapital: string; // Note: string
}[]

{
  id: string;
  name: string;
  startingCapital: string; // Note: string
}[]

However, when I log the actual value of startingCapital, it's a number:

console.log(typeof result[0].startingCapital); // Outputs: "number"

console.log(typeof result[0].startingCapital); // Outputs: "number"

Expected behavior: startingCapital should be a string to match the TypeScript definition. Actual behavior: startingCapital is a number.
My version are :
"drizzle-orm": "^0.33.0",
"drizzle-kit": "^0.24.2"

I just want the type and runtime value to match, regardless of whether it's a string or a number

Numeric type returns number instead of string as defined in TypeScript

Hello, I'm trying Drizzle ORM with PostgreSQL and TypeScript. I've noticed a discrepancy between the TypeScript definitions and the actual runtime behavior for numeric fields.

Schema definition:

export const bankrolls = pgTable('bankrolls', {
  id: uuid('id').primaryKey(),
  name: varchar('name'),
  startingCapital: numeric('starting_capital', { precision: 8, scale: 2 }),
});

export const bankrolls = pgTable('bankrolls', {
  id: uuid('id').primaryKey(),
  name: varchar('name'),
  startingCapital: numeric('starting_capital', { precision: 8, scale: 2 }),
});

The request

async all(userId: string): Promise<BankrollsViewModel[]> {
  const result = await this.sqlConnection
    .select()
    .from(bankrolls)
    .where(eq(bankrolls.userId, userId));
  return result;
}

async all(userId: string): Promise<BankrollsViewModel[]> {
  const result = await this.sqlConnection
    .select()
    .from(bankrolls)
    .where(eq(bankrolls.userId, userId));
  return result;
}

The type of result is inferred as:

{
  id: string;
  name: string;
  startingCapital: string; // Note: string
}[]

{
  id: string;
  name: string;
  startingCapital: string; // Note: string
}[]

However, when I log the actual value of startingCapital, it's a number:

console.log(typeof result[0].startingCapital); // Outputs: "number"

console.log(typeof result[0].startingCapital); // Outputs: "number"

Numeric type returns number instead of string as defined in TypeScript

Similar Threads

Numeric type returns number instead of string as defined in TypeScript

Similar Threads

Similar Threads

Similar Threads