how to filter data array_agg from postgresql

Question

I have view at postgres db from this query

SELECT order_product.order_id,
  array_agg(order_product.product_id) AS itemset 
FROM order_product
GROUP BY order_product.order_id
ORDER BY order_product.order_id;

and this is the structure look like:

And the question is, how can U filter data at (itemset) just show where the value is more than 1 (example: don't show = {8}, just show the value when containing 2 data or more like this = {8,10})

user330315 · Accepted Answer · 2020-06-08 17:25:08Z

1

Use the having() clause:

SELECT op.order_id,
       array_agg(op.product_id) AS itemset 
FROM order_product op
GROUP BY op.order_id
HAVING count(*) > 1 --<< here
ORDER BY op.order_id;

answered Jun 8, 2020 at 17:25

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Reynaldo Over a year ago

thank you that solved my problem, very grateful for your answer

Collectives™ on Stack Overflow

how to filter data array_agg from postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related