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;

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:

No replies yetBe the first to reply to this messageJoin

Appending to array OnConflictUpdate()? (Postgres)

Similar Threads

Similar Threads

Similar Threads