How to use LIMIT and OFFSET in Postgres' json_agg() function

Описание

How to use LIMIT and OFFSET in Postgres' json_agg() function
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/268838/sirjon)Sirjon |
(dba.stackexchange.com/users/176905/laurenz-albe)Laurenz Albe |
(dba.stackexchange.com/users/3684/erwin-brandstetter)Erwin Brandstetter |
A special thanks goes out to the (https://dba.stackexchange.com/questions/323888/how-to-use-limit-and-offset-in-postgres-json-agg-function)Stackexchange community |

I wish you all a wonderful day! Stay safe :)

postgresql aggregate postgresql-performance