Postgresql GROUP_CONCAT equivalent?

by

Since 9.0 this is even easier:

SELECT id, 
       string_agg(some_column, ',')
FROM the_table
GROUP BY id

More Related Contents:

  1. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  2. Refactor a PL/pgSQL function to return the output of various SELECT queries
  3. PostgreSQL “Column does not exist” but it actually does
  4. Is SELECT or INSERT in a function prone to race conditions?
  5. Any downsides of using data type “text” for storing strings?
  6. PostgreSQL: using a calculated column in the same query
  7. Optimise PostgreSQL for fast testing
  8. Fast way to discover the row count of a table in PostgreSQL
  9. How to delete duplicate rows without unique identifier
  10. Is there something like a zip() function in PostgreSQL that combines two arrays?
  11. Serial numbers per group of rows for compound key
  12. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  13. Postgres analogue to CROSS APPLY in SQL Server
  14. Postgres not using index when index scan is much better option
  15. SQL update fields of one table from fields of another one
  16. Postgres – Function to return the intersection of 2 ARRAYs?
  17. How to store array or multiple values in one column
  18. convert Postgres geometry format to WKT
  19. Which datatype should be used for currency?
  20. Produce DISTINCT values in STRING_AGG
  21. How to return two columns with function
  22. COPY with dynamic file name
  23. Table or column name cannot start with numeric?
  24. PostgreSQL column ‘foo’ does not exist
  25. Prepared Statement on Postgresql in Rails
  26. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  27. Postgresql query between date ranges
  28. How to use SQL LIKE condition with multiple values in PostgreSQL?
  29. Why isn’t row level security enabled for Postgres views?
  30. Is there a postgres CLOSEST operator?

Leave a Comment