yayza_ Comments - Answer Overflow

yayza_

•Created by yayza_ on 3/26/2025 in #query-showcase

A pagination helper

i tried to do that, but I ended up with an error because my main query uses a subquery, so I had to keep select clause too,

    const subQuery = query.clearLimit().clearOffset();
    const countResult = await db
        .selectFrom(subQuery)
        .select(sql<number>`COUNT(*)`.as('count'))
        .executeTakeFirst();

    const subQuery = query.clearLimit().clearOffset();
    const countResult = await db
        .selectFrom(subQuery)
        .select(sql<number>`COUNT(*)`.as('count'))
        .executeTakeFirst();

but that means my main query would select rows and run agg functions again 🤔 just to get a count. i tested both queries and i'm getting same counts so far but i'll keep trying to do it like you mentioned because i definitely don't want removing groupBy to have an unintended effect

4 replies

KKysely

•Created by yayza_ on 3/26/2025 in #query-showcase

A pagination helper

lmk if i can make it better.. i'm still learning 🙂

4 replies

KKysely

•Created by tzezar on 3/6/2025 in #help

Inconsistent Typing of NUMERIC Fields with jsonBuildObject

thank you for the clue ... realized it was a node-postgres issue. 😅

10 replies

KKysely

•Created by tzezar on 3/6/2025 in #help

Inconsistent Typing of NUMERIC Fields with jsonBuildObject

just when i use it jsonBuildObject btw

10 replies

KKysely

•Created by tzezar on 3/6/2025 in #help

Inconsistent Typing of NUMERIC Fields with jsonBuildObject

I recently came a cross this as well , when a property is numeric i have to cast it to text or it will change the value to a number and i lose precision price: sql<string>${eb.ref('product.price')}::TEXT,

10 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

oh, my problem was that kysely-codegen doesn't support json columns yet, but i used the codegen and modified those manually now it works . thanks for the point in the right direction!

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

oh okay, I just ran the codegen I didnt create the type myself for that column but i'll do that now 🙏

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

7 replies

KKysely

•Created by yayza_ on 7/11/2024 in #help

How do I compare to a value in a jsonb column?

this works and it's based on what I read from hovering over ref() and reading the documentation:

// In the next example we use ref to reference a nested JSON property:

db.selectFrom('person')
  .where(({ eb, ref }) => eb(
    ref('address', '->').key('state').key('abbr'),
    '=',
    'CA'
  ))
  .selectAll()

// In the next example we use ref to reference a nested JSON property:

db.selectFrom('person')
  .where(({ eb, ref }) => eb(
    ref('address', '->').key('state').key('abbr'),
    '=',
    'CA'
  ))
  .selectAll()

The only problem is that I have to use //@ts-ignore to bypass that error 😅 , which makes me assume I'm doing it wrong

7 replies

Gaming

Programming