I Hate Advantage Database
-
I hate Advantage Database.
Long story short: Advantage Database does not include an aggregate function that concatenates items together (like Oracle's
listagg, or something likefoldl (++) [])So now I'm going to have to calculate the aggregate value manually, in C#. Which means I will have to change how I handle 60-something columns.
Motherfuckers.
-
How much SQL does it support? Could you use a recursive CTE as a workaround?
-
@Captain said in I Hate Advantage Database:
listagg
In T-SQL/MS SQL Server, you can "trick" the XML generator into doing this.
ListAGG in SQLSERVER
I'm trying to aggregate a 'STRING' field in SQLServer. I would like to find the same function LISTAGG like in Oracle . Do you know how to do the same function or an another method? For Example, ...
See if that works for you as a workaround.
-
Oracle's only had it since 11.2. Mysql has had it for ages though.
-
This post is deleted!
-
@PleegWat said in I Hate Advantage Database:
Oracle's only had it since 11.2.
There was
wm_concatat least in 10. It was undocumented and it changed from returning avarchar2to aclobfrom 10 -> 11 and then went away entirely in 12. But it got the job done, and you could use thedistinctmodifier with it, which you can't withlistagg, which means that sometimes it's a bitch to replace.
-
@Captain said in I Hate Advantage Database:
So now I'm going to have to calculate the aggregate value manually, in C#.
"Like an animal" you forgot to add.
-
@Captain said in I Hate Advantage Database:
aggregate function that concatenates items together
Postgres has a shitload of those.
-
@FrostCat said in I Hate Advantage Database:
@Captain said in I Hate Advantage Database:
So now I'm going to have to calculate the aggregate value manually, in C#.
"Like an animal" you forgot to add.
Well duh, it's not Haskell.
