`string_agg` in postgresql maximum length

Question

For example, the function string_agg(name,',') returns abc,d,e,f,g.
Is there any way to set maximum length for the function string_agg to return only first N characters abc,d,e,... or ab...?
P.S. No matter how it will be splitted.

Have you tried to limit the number of rows with LIMIT 10 for example? — Joël Salamin
– Joël Salamin, Commented Oct 3, 2014 at 12:16

Gordon Linoff · Accepted Answer · 2014-10-03 12:14:16Z

1

You can just take the first "n" characters after doing the aggregation:

select left(string_agg(name, ','), N) as FirstN

answered Oct 3, 2014 at 12:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

`string_agg` in postgresql maximum length

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related