Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      It would be nice to have a UDF like CONCAT for GROUP BY.

      For example,

      SELECT user, CONCAT(post) AS posts
      FROM tablename
      GROUP BY user

      ...which would return all of the posts concatenated together, separated by a single whitespace. So if the table was like this:

      user\tpost
      1\tHi there this is my first post
      1\tpost number two
      2\tI'm a different user!

      then the above code would return
      user\tposts
      1\tHi there this is my first post post number two
      2\tI'm a different user!

      Alternate form:
      CONCAT(string text, string separator) which would put the separator between each block of text.

        Activity

        Adam Kramer created issue -
        Adam Kramer made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Duplicate [ 3 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development