Pedro-Juan Ferrer Matoses
  • Tips & Tricks
  • Archives

Convert a resultset into a comma separated field

Date Tue 31 May 2016 Tags postgres / resultset / fields / comma
SELECT cprov, array_to_string(ARRAY(SELECT cine FROM ciudades.ciudades where cprov = c.cprov),',') FROM ciudades.ciudades c WHERE poblacion > 14999 GROUP BY cprov
  • Social

    • Twitter
    • LinkedIn
    • Github
  • Links

    • Geomaticblog
    • Geoinquietos VLC
    • Arakua Urban Lab
    • Barrilungos

© 2017 pjfm · Powered by pelican-bootstrap3, Pelican, Bootstrap

Back to top