badri · February 14, 2016 03:18
diff --git a/final-cte.sql b/final-cte.sql
 WITH data AS(
 select array_to_json(array_agg(row_to_json(t))) as data
    from (
     SELECT id, name, COALESCE(get_children(id), '[]') as children from genres
    ) t
 ) SELECT get_tree(data) from data;
	WITH data AS(
	select array_to_json(array_agg(row_to_json(t))) as data
	from (
	SELECT id, name, COALESCE(get_children(id), '[]') as children from genres
	) t
	) SELECT get_tree(data) from data;