Sequences

Bunny Database includes the generate_series table-valued function.

Module	What it does
`generate_series(start [, stop [, step]])`	A sequence of integers as a table.

SELECT value FROM generate_series(1, 10, 3);   -- 1, 4, 7, 10
SELECT value FROM generate_series(5, 1, -2);   -- 5, 3, 1

A step of 0 is treated as 1. Without stop, the series is unbounded, so add a LIMIT. The hidden start, stop, and step columns are readable.

Example: fill gaps in a time series

SELECT days.value AS day, coalesce(sum(s.amount), 0) AS total
FROM generate_series(1, 31) AS days
LEFT JOIN sales s ON s.day = days.value
GROUP BY days.value;

Last modified on November 2, 2026

Documentation

Connect

Tools

Reference

Example: fill gaps in a time series

​Example: fill gaps in a time series

Example: fill gaps in a time series