Skip to content

Instantly share code, notes, and snippets.

@jjl

jjl/json_array_elements_text.sql

Created January 31, 2014 19:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jjl/8740872 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jjl/8740872 to your computer and use it in GitHub Desktop.
Download ZIP
The missing useful postgresql json function
Raw
json_array_elements_text.sql
CREATE OR REPLACE FUNCTION json_array_elements_text(arr json) RETURNS SETOF text AS $$
BEGIN
RETURN QUERY SELECT arr->>i
FROM generate_series(0,json_array_length(arr)-1) i;
END
$$ LANGUAGE plpgsql;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment