title: concat column values to one line in Vertica SQL
body: <p>Example table:</p>
  
  <pre><code>id      some_column
  1        value1
  2        value2
  2        value3
  3        value4
  1        value5
  </code></pre>
  
  <p>Expected result:</p>
  
  <pre><code>id some_column
  1  value1, value5
  2  value2, value3
  3  value4
  </code></pre>
  
  <p>I tried <code>select id, concat(some_column) from table_name group by id</code></p>
  
  <p>It says concat does not exist or permission denied...</p>