The Vertica Database Forums

Hi,
I am working on a DB migration project, in which the database is getting migrated from Oracle to Vertica, which also includes the conversion of PL/SQL procedures for vertica.(I am doing this in java with vertica SQL and JDBC).

One of the procedure is having a query like >>"select rtrim(xmlagg(xmlelement(e, group_desc||',')).extract('//text()'),',') from <table> where id in();" Do we have an equivalent function in vertica for xmlagg? or how this can be implemented in vertica?

Hi,

There is not an xmlagg function in Vertica yet, but there is an XML extension package available here:

https://github.com/vertica/Vertica-Exte ... ml_package

Maybe the "XSLT function" that is included can help?