string_agg¶
Description¶
Returns concatenated input values, separated by the delimiter. The expression must be a string column. The delimiter must be a string constant (it may be an empty string). If no ordering is specified, the default ordering is that of the invoking verb, which is generally the ‘valid_from’ timestamp, ascending.
Return type¶
string
Domain¶
This is an aggregate function (aggregates rows over a group in aggregate verbs.)
Categories¶
Usage¶
string_agg( expr, delimiter [ , order_by ] )
Argument |
Type |
Required |
Multiple |
---|---|---|---|
expr |
string |
Required |
Only one |
delimiter |
string |
Required |
Only one |
order_by |
ordering |
Optional |
Only one |
Examples¶
statsby nicknames:string_agg(nickname, ", ", order_by(email)), group_by(uid, fullname)
A list of all nicknames for each individual in the organization; for users with more than one nickname they will be sorted by email address.