How do I make .returning() return only the inserted value instead of array

Here I have

createResource

createResource

to insert a single record. The result from .returning is an array. I am using neon postgres db

TekipepsOP•6/20/24, 5:04 PM

In the return type, it also shows as array

Ling Mai Jiānguǒ•6/20/24, 5:18 PM

It returns an array composed only of the records you've inserted in that query, no? If you know that there will be one record, since that is what you're inserting, just return createdResource[0]!return createdResource[0]!

TekipepsOP•6/20/24, 5:21 PM

okay, the return type is not specified in the docs. made me think something was wrong

Ling Mai Jiānguǒ•6/20/24, 5:23 PM

I see, values is meant to take in (spread) array inside, so it works as intended, though I agree that it might be not very clear at the first glance.

kbemaster•6/20/24, 5:24 PM

I like to do the following, when I know I just return 1 element

const [insertedValue] = db.insert(table).values(someValue).returning()

const [insertedValue] = db.insert(table).values(someValue).returning()

Kkbemaster I like to do the following, when I know I just return 1 element ```ts const [in...

TekipepsOP•6/20/24, 5:24 PM

Ah i see

Ling Mai Jiānguǒ•6/20/24, 5:24 PM

With some sqlite drivers, you can add

.get()

.get()

to the query to specify that it's single or no records returned, that's what I usually do.

TekipepsOP•6/20/24, 5:24 PM

.returning()

.returning()

always returns an array regardless

Ling Mai Jiānguǒ•6/20/24, 5:25 PM

Yep

TekipepsOP•6/20/24, 5:25 PM

thanks

How do I make .returning() return only the inserted value instead of array

Similar Threads

Similar Threads

Similar Threads