v.24.3New Feature
Add generate_series as a table function for compatibility with PostgreSQL
Addgenerate_seriesas a table function (compatibility alias for PostgreSQL to the existingnumbersfunction). This function generates table with an arithmetic progression with natural numbers. #59390 (divanik).
Why it matters
This feature provides PostgreSQL users with a familiargenerate_series function for generating sequences of numbers, improving cross-database compatibility and easing migration or hybrid-use scenarios in ClickHouse.How to use it
Use thegenerate_series function in queries just like the existing numbers function to produce a table of natural numbers in an arithmetic progression. For example:SELECT * FROM generate_series(0, 9);