Drizzle Team•8mo ago

Appending to array OnConflictUpdate()? (Postgres)

full question on stack overflow: https://stackoverflow.com/questions/78246191/error-appending-to-array-oonconflictupdaste-using-drizzle-orm-postgresql Am I missing something? Found nothing on it on the docs. How can I achieve this in Drizzle?

INSERT INTO users (email, ip_list, name, phone, is_admin, password)
VALUES ($1, $2, $3, $4, $5, $6)
ON CONFLICT (email) DO UPDATE
SET ip_list = array_append(users.ip_list, $7::INET[])
RETURNING id;

INSERT INTO users (email, ip_list, name, phone, is_admin, password)
VALUES ($1, $2, $3, $4, $5, $6)
ON CONFLICT (email) DO UPDATE
SET ip_list = array_append(users.ip_list, $7::INET[])
RETURNING id;

Stack Overflow

Error appending to array oOnConflictUpdaste using Drizzle ORM (Post...

My Typescript code using Drizzle ORM to insert into a 'users' table in a Postgres database: const res = await db.insert(UsersTable) .values(newUser) .onConflictDoUpdate({ target:

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Appending to array OnConflictUpdate()? (Postgres)