Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-2160

Implement string_agg function.

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 0.11.3
    • 0.12.0
    • Function/UDF
    • None

    Description

      I'll implement to concatenate the strings of a field within a group by query.

      I have a table:
      ID COMPANY_ID EMPLOYEE
      1 1 Anna
      2 1 Bill
      3 2 Carol
      4 2 Dave

      and I wanted to group by company_id to get something like:

      SELECT company_id, string_agg(employee, ', ')
      FROM mytable
      GROUP BY company_id;

      COMPANY_ID EMPLOYEE
      1 Anna, Bill
      2 Carol, Dave

      PostgreSQL supports string_agg function.
      http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE

      Thank you.

      Attachments

        Issue Links

          Activity

            People

              combine Byunghwa Yun
              combine Byunghwa Yun
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: