Skip to content

Instantly share code, notes, and snippets.

@miensol

miensol/count_in_json_aray.sql

Created September 29, 2014 11:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save miensol/b589a8e306d8b5755f42 to your computer and use it in GitHub Desktop.
Save miensol/b589a8e306d8b5755f42 to your computer and use it in GitHub Desktop.
Download ZIP
Count elements in json array
Raw
count_in_json_aray.sql
select count(ja.id), elem.value::varchar from
json_answer ja,
json_array_elements(ja.answer) as elem
group by elem.value::varchar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment