How to increment field in PG
logins: integer('logins').default(1).notNull(),logins: integer('logins').default(1).notNull(),await db
.update(users)
.set({ logins: sql`${users.logins} + 1` })
.where(eq(users.id, user.id));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" = $2ERROR: invalid input syntax for type integer: "[object Object]"
CONTEXT: unnamed portal parameter $1 = '...'
STATEMENT: update "User" set "logins" = $1 where "User"."id" = $2This doesn't seem to work for me