thelinuxlich

Explore posts from servers

CDCloudflare DevelopersRRailwayKKysely

PostsComments

KKysely

•Created by thelinuxlich on 9/20/2024 in #help

eb.fn.coalesce on a subquery

if I write eb.fn.coalesce(subquery.limit(1), 'foo') Kysely won't recognize the subquery is returning a single value

6 replies

KKysely

•Created by thelinuxlich on 9/20/2024 in #help

eb.fn.coalesce on a subquery

I think it's the same issue we had with CASE https://discord.com/channels/890118421587578920/1184681470531469423

6 replies

KKysely

•Created by Adophilus on 4/2/2024 in #help

Is it possible to get the total count while fetching rows in a single query?

not repeated per row would be a CTE

9 replies

KKysely

•Created by Adophilus on 4/2/2024 in #help

Is it possible to get the total count while fetching rows in a single query?

Maybe use a window function?

9 replies