Is there an analogous function to generate_array in PostgreSQL?

Question

Here's my query for reference:

with weekly_periods as (
  select ticket_id,
         start_time_in_minutes_from_week,
         raw_delta_in_minutes,
         schedule_id,
         week_number,
         greatest(0, start_time_in_minutes_from_week - week_number * (7*24*60)) as ticket_week_start_time,
         least(start_time_in_minutes_from_week + raw_delta_in_minutes - week_number * (7*24*60), (7*24*60)) as ticket_week_end_time
  from ticket_solved_time, unnest(generate_array(0, floor((start_time_in_minutes_from_week + raw_delta_in_minutes) / (7*24*60)), 1)) as week_number
)

I have tried generate_series and also the array functions, but I am not too familiar with the PostgreSQL syntax.

It sounds like you answered your own question, right? The function is called generate_series in PostgreSQL. What is it that you are trying to do? Please provide sample input data and expected output. — Elliott Brossard
– Elliott Brossard, Commented Aug 2, 2018 at 18:59
Did you tried just ... from ticket_solved_time, generate_series(0, floor((start_time_in_minutes_from_week + raw_delta_in_minutes) / (7*24*60)), 1) as week_number? Note that the step value 1 is default in this case so it could be omitted. — Abelisto
– Abelisto, Commented Aug 2, 2018 at 19:09

Elliott Brossard · Accepted Answer · 2018-08-02 19:02:05Z

2

You can use something like below in PostgreSQL to generate random integer array for example

select array_agg(round(random() * (max - min)) + min) 
from generate_series(0, elements)

Note: generate_series function has many signatures that allow you to control what you will get out

edited Aug 2, 2018 at 19:02

Elliott Brossard

34k2 gold badges75 silver badges105 bronze badges

answered Aug 2, 2018 at 19:00

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there an analogous function to generate_array in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related