Skip to content

Instantly share code, notes, and snippets.

@Sillson

Sillson/jsonb_to_pg_array.sql

Created June 26, 2018 03:36
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 Sillson/13fd024b753f3bfead26086e2dcc6783 to your computer and use it in GitHub Desktop.
Save Sillson/13fd024b753f3bfead26086e2dcc6783 to your computer and use it in GitHub Desktop.
Download ZIP
jsonb_to_pg_array
Raw
jsonb_to_pg_array.sql
CREATE OR REPLACE FUNCTION jsonb_array_to_text_array(
p_input jsonb
) RETURNS TEXT[] AS $BODY$
DECLARE v_output text[];
BEGIN
SELECT array_agg(ary)::text[]
INTO v_output
FROM jsonb_array_elements_text(p_input) AS ary;
RETURN v_output;
END;
$BODY$
LANGUAGE plpgsql VOLATILE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment