Sha256: 3072f16e429a235987ea885187159bc41515765dd407a212848c70a2f266f90f
Contents?: true
Size: 516 Bytes
Versions: 33
Compression:
Stored size: 516 Bytes
Contents
START TRANSACTION;
-- Convert a jsonb array or jsonb value to a jsonb array
CREATE or replace FUNCTION "fn_contentful_jsonb_any_to_jsonb_array"(potential_arr jsonb) RETURNS jsonb AS $$
DECLARE
result jsonb;
BEGIN
SELECT
CASE
WHEN jsonb_typeof(potential_arr) = 'array' THEN potential_arr
ELSE jsonb_build_array(potential_arr)
END
INTO result;
RETURN result;
END;
$$ LANGUAGE 'plpgsql';
INSERT INTO wcc_contentful_schema_version
VALUES (2);
COMMIT;
Version data entries
33 entries across 33 versions & 1 rubygems