4 replies

Update and return a single row only when using .update()?

Hi,

I have the following drizzle code which updates levels in a table.

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

Is it possible to only update a single row in the levels table instead of all that match the

where

where

clause? I'm asking this because I want the

returning()

returning()

value to be a single object instead of an array of objects.

I'm fairly new to pg and drizzle so I apologise if it's a silly question xD

Drizzle Team•3y ago•

4 replies

Avraj

Update and return a single row only when using .update()?

Hi,

I have the following drizzle code which updates levels in a table.

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

Is it possible to only update a single row in the levels table instead of all that match the

where

where

clause? I'm asking this because I want the

returning()

returning()

value to be a single object instead of an array of objects.

I'm fairly new to pg and drizzle so I apologise if it's a silly question xD

Update and return a single row only when using .update()?

Similar Threads

Update and return a single row only when using .update()?

Similar Threads

Similar Threads

Similar Threads