Postgres hopes to add string.agg to replace GroupConcat

[zengshun2019]

Describe the feature

count, err := qu.WithContext(ctx).
Select(
qu.UID,
qu.Name,
qu.Avatar,
qu.PhoneNumber,
qu.Email,
qu.Gender,
qu.BirthDay,
qu.Address,
qu.Desc,
qu.IsDefault,
qu.Status,
qr.Name.GroupConcat().As("Role"),
qd.Name.As("Dept"),
qu.LastLoginTime,
qu.CreatedAt,
).
Where(where...).
LeftJoin(qur, qur.UID.EqCol(qu.UID)).
LeftJoin(qr, qr.Label.EqCol(qur.RoleLabel)).
LeftJoin(qd, qd.Label.EqCol(qu.DepartmentLabel)).
Group(
qu.ID,
qu.UID,
qu.Name,
qu.Avatar,
qu.PhoneNumber,
qu.Email,
qu.Gender,
qu.BirthDay,
qu.Address,
qu.Desc,
qu.IsDefault,
qu.Status,
qd.Name,
qu.LastLoginTime,
qu.CreatedAt,
).
Order(order).
ScanByPage(&result, (s.CurrentPage-1)*s.PageSize, s.PageSize)

Motivation

Related Issues