liteyear.

PostsComments

KKysely

•Created by liteyear. on 8/31/2023 in #help

How can I cast a jsonb value to a float8 in query?

I have a query that has a jsonb value in the db that will always be a number, and I want to sum it. how can I change this value to a number fn.sum<number>('value') what I want is: fn.sum<number>('value'::float8)

5 replies

KKysely

•Created by liteyear. on 8/29/2023 in #help

How can I write a query that does multiple insertions at once?

I have an array of Ids that I want to assign to a single id in a "bridging" table for a many to many relationship: ie: singleId: id1 singleId: id2 singleId: id3

10 replies

KKysely

•Created by liteyear. on 8/28/2023 in #help

How can I write a count query?

Do I have to use raw SQL?

10 replies