admin管理员组

文章数量:1335585

If Supabase returns data from a table that contains columns parentid and childname such as (with the JavaScript API):

{
    "data": [
        {
          "parentid": 1,
          "childname": "alice"
        },
        {
          "parentid": 1,
          "childname": "bobby"
        },
        {
          "parentid": 2,
          "childname": "charlie"
        },
    ],
    "status": 200,
    "statusText": "OK"
}

is it possible to create a View or SQL Function that groups rows with identical parentid into arrays, like this:

{
    "data": [
        {
          "parentid": 1,
          "children": [
              {
                  "childname": "alice"
              },
              {
                  "childname": "bobby"
              },
          ]
        },
        {
          "parentid": 2,
          "children": [
              {
                  "childname": "charlie"
              }
          ]
        },
    ],
    "status": 200,
    "statusText": "OK"
}

I could form this aggregation within the client, but for efficiency I would prefer that this happens within the database.

本文标签： sqlGroup Supabase queries with array aggregationStack Overflow

版权声明：本文标题：sql - Group Supabase queries with array aggregation - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742383828a2464622.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。