DT
Drizzle Team•9mo ago
JuaniS

COALESCE to json array not working in sql function

I am using the sql operator in a postgres db and when I try to coalesece to an empty array it doesn't work as expected. It returns null. This is how I am doing it. Is it wrong? 
 const productItemsImagesSQLAgg = sql<ProductItemImages[]>`
    COALESCE(
      JSON_AGG(
        JSON_BUILD_OBJECT(
          'url', ${images.url}, 
          'key', ${images.key}
        )
      ) FILTER (WHERE ${images.id} IS NOT NULL), 
    '[]'::JSON
    )
    `.as('images');
 const productItemsImagesSQLAgg = sql<ProductItemImages[]>`
    COALESCE(
      JSON_AGG(
        JSON_BUILD_OBJECT(
          'url', ${images.url}, 
          'key', ${images.key}
        )
      ) FILTER (WHERE ${images.id} IS NOT NULL), 
    '[]'::JSON
    )
    `.as('images');
2 Replies
JuaniS
JuaniSOP•8mo ago
as
Denys Bondarenko
Denys Bondarenko•3mo ago
any updates on this? I face the same issue @JuaniS

Did you find this page helpful?