JSONB array using JSON_ARRAYAGG. SELECT json_arrayagg(author.id) FROM author ... For this, use the ORDER BY clause in JSON_ARRAYAGG.
確定! 回上一頁