Pedro-Juan Ferrer Matoses
  • Tips & Tricks
  • Archives

Convert a resultset into a comma separated field

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
more ...

  • Social

    • Twitter
    • LinkedIn
    • Github
  • Links

    • Geomaticblog
    • Geoinquietos VLC
    • Arakua Urban Lab
    • Barrilungos

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

Back to top