How to increment field in PG

logins: integer('logins').default(1).notNull(),

await db
  .update(users)
  .set({ logins: sql`${users.logins} + 1` })
  .where(eq(users.id, user.id));

ERROR:  invalid input syntax for type integer: "[object Object]"
CONTEXT:  unnamed portal parameter $1 = '...'
STATEMENT:  update "User" set "logins" = $1 where "User"."id" = $2

This doesn't seem to work for me
Was this page helpful?