Breaking News: Grepper is joining You.com. Read the official announcement!

Raw into column

Satsara Gunaratne answered on June 3, 2022 Popularity 1/10 Helpfulness 1/10

answer Raw into column

Raw into column

Comment

CREATE or replace FUNCTION budget_function(num integer)
RETURNS TABLE(budget bigint, dub_date text)
LANGUAGE plpgsql
AS $function$
begin

    return query
        SELECT SUM(t1.budget) budget,
               string_agg(TO_CHAR("bud_date",'YYYY-MM-DD'),'-') date
        FROM (
          SELECT *, ROW_NUMBER() OVER(ORDER BY "bud_date") rn
          FROM budget_table
        ) t1
        GROUP BY (rn - 1)/num
        ORDER BY (rn - 1)/num;
    
end
$function$
;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: raw sql

Link to this answer
Share Copy Link