oeon/gist.sql

Created January 7, 2020 05:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/oeon/e79343ed661a76eeb544e4f239059c61.js"></script>
Save oeon/e79343ed661a76eeb544e4f239059c61 to your computer and use it in GitHub Desktop.

Download ZIP

unnested photo array - captions...aggregated back together

Raw

select _record_id, string_agg(unnest, ', ') as photos, string_agg(photos_captions, ', ') as photos_captions from (select r._record_id, r.unnest, k.labels as photos_captions from records r join rek k on k.photo = r.unnest order by _record_id) a group by _record_id order by _record_id

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment