limit amount of objects in array of postgresql jsonb_agg

André

I have this query:

SELECT jsonb_agg(jsonb_build_object('me_id', me_id)) from message

and got the following result:

[{"me_id": 2064}, {"me_id": 2065}, {"me_id": 2066}, {"me_id": 2067}, {"me_id": 2068}, {"me_id": 2069}, {"me_id": 2070}, {"me_id": 2071}]

so far so good. However I want to LIMIT the amount of objects in the array. For instance to 3. But adding LIMIT 3 is not working.

How can I limit the amount of objects within the array?

EDIT: @GMB's answer solved it. Thank you!

GMB

You would need a subquery:

select jsonb_agg(jsonb_build_object('me_id', me_id)) 
from (select * from message order by me_id limit 3) t

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-12-26

Comments

0 comments

Array of objects in postgresql

Postgresql query array of objects in JSONB field

How to put a limit on the amount of objects in an ArrayList

Adding unknown amount of objects to Array via function

insert jsonb data in postgresql, option array or objects, valid way

Filtering unique names of an array with massive amount of objects

Postgresql get keys from array of objects in JSONB field

Search by date in array of objects within PostgreSQL JSONB Column

Limit query by sum of attributes of objects in Rails and Postgresql

Can PostgreSQL JOIN on jsonb array objects?

PostgreSQL - Add key to each objects of an JSONB array

Use data to define amount of objects in Array

Filter array of objects by amount property

How to iterate over PostgreSQL jsonb array of objects and modify elements?

PostgreSQL query on a JSONB Array of Objects

Update array of objects in JSONB format PostgreSQL

How do i limit the amount of objects are instantiated?

PostgreSQL aggregate function calls cannot be nested using jsonb_agg function

Postgresql Using array_agg and jsonb_build_object

Postgresql get keys from nested array of objects in JSONB field

Update the value of an attribute in a postgresql jsonb array of objects across muliple records

push the total amount of objects to an array

Limit List's objects amount - SwiftUi

Postgresql remove object from jsonb array of objects by key value

Constructor that receives an arbitrary amount of objects or an array of objects

PostgreSQL: Does jsonb sort Objects in array?

How to merge a JSONB array of objects into a single object in PostgreSQL

How to group by the amount of values in an array in postgresql

How could I limit the amount of items in an array (js)

TOP Ranking

Article

limit amount of objects in array of postgresql jsonb_agg

limit amount of objects in array of postgresql jsonb_agg

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

Is this docker-for-mac password dialog legit?

Double spacing in rmarkdown pdf

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Vector input in shiny R and then use it

Assembly definition can't resolve namespaces from external packages

Bootstrap 5 Static Modal Still Closes when I Click Outside

Can a 32-bit antivirus program protect you from 64-bit threats

Using Response.Redirect with Friendly URLS in ASP.NET

BigQuery - concatenate ignoring NULL

How to how increase/decrease compared to adjacent cell

AirflowException: Celery command failed - The recorded hostname does not match this instance's hostname

@RefreshScope annotated Bean registered through BeanDefinitionRegistryPostProcessor not getting refreshed on Cloud Config changes

MTKView Displaying Wide Gamut P3 Colorspace

Displaying attached image with post how to i get it to display

Python connect to firebird docker database