store date fields (day of week, hour, minute) vs. using extract to query postgres

medium_date_fields_vs_extract_int_between.sql

-- returns a random number from within a range (inclusive)
create or replace function int_between(
  in low int,
  in high int,
  out int
)
returns int
language sql
as $$
    select floor(random() * (high - low + 1) + low)::int
$$;