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.
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_concat
at least in 10. It was undocumented and it changed from returning avarchar2
to aclob
from 10 -> 11 and then went away entirely in 12. But it got the job done, and you could use thedistinct
modifier 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.