Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  RFE: Add function LISTAGG like DB2 and Oracle

    Posted Tue April 14, 2020 01:30 PM
    Hi!
    I just added a new RFE, if you are interested, please vote!

    Add function LISTAGG like DB2 and Oracle

    https://ibm-data-and-ai.ideas.aha.io/ideas/ISP-I-203


    ------------------------------
    Cesar Martins
    ------------------------------

    #Informix


  • 2.  RE: RFE: Add function LISTAGG like DB2 and Oracle

    Posted Tue April 14, 2020 07:30 PM
    I just voted.
    Here is an example that implements the same aggregate function as listagg.
    https://stackoverflow.com/questions/715350/show-a-one-to-many-relationship-as-2-columns-1-unique-row-id-comma-separate
    Of course, functions such as xmlagg and listagg are used extensively, so it would be nice if they existed as default built-in functions.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message