python-sql

Bug 69

classification
Title: Add STRING_AGG function
Type: rfe Severity: normal
Components: Versions:
process
Status: Resolution:
Dependencies: Superseder:
Assigned To: Nosy List: ced, smn
Priority: low Keywords:

Created on 2021-02-12 11:49 by smn, last changed 2021-02-12 12:15 by ced.

Messages
msg116 Author: [hidden] (smn) Date: 2021-02-12 11:49
This function has different names depending on backend:
- postgres & sql server: STRING_AGG
- sqlite: group_concat
- oracle: LISTAGG

How I should deal with it?
msg121 Author: [hidden] (ced) Date: 2021-02-12 12:15
Normally we include only standard SQL function.
LISTAGG has been added only in SQL:2016 and as optional feature [1]. It is not widely supported.
I think we should wait for larger adoption before including it.


[1] https://modern-sql.com/feature/listagg
History
Date User Action Args
2021-02-12 12:15:45cedsetmessages: + msg121
nosy: + ced
priority: low
severity: normal
type: rfe
2021-02-12 11:49:34smncreate