Top "Generate-series" questions

REDSHIFT: How can I generate a series of numbers without creating a table called "numbers" in redshift (Postgres 8.0.2)?

I need to create an empty time table series for a report so I can left join activity from several …

amazon-redshift generate-series postgresql-8.0

Postgres - how to return rows with 0 count for missing data?

I have unevenly distributed data(wrt date) for a few years (2003-2008). I want to query data for a given …

python database postgresql left-join generate-series

Cumulative sum of values by month, filling in for missing months

I have this data table and I'm wondering if is possible create a query that get a cumulative sum by …

sql postgresql aggregate-functions window-functions generate-series

Postgres generate_series

What I want to is to make statistics on a table and for this I'm using generate_series(); Here is …

sql postgresql generate-series

Generate series of week intervals for given month

In a Postgres 9.1 database, I am trying to generate a series of weeks for a given month but with some …

sql postgresql time-series weekday generate-series

Rails ActiveRecord Arels: Unsupported argument type: String. Construct an Arel node instead

I'm using Arels for creating query. In this query, I use generate_series function. Here is my code: def generate_…

sql ruby-on-rails ruby activerecord generate-series

generate_series() method fails in Redshift

When I run the SQL Query: select generate_series(0,g) from ( select date(date1) - date(date2) as g from …

amazon-redshift generate-series

Inserting values (generate_series) - how can I reuse/cycle the numbers, e.g, 1,2,3,1,2,3

I am using generate_series to insert values in a table. And generate_series insert values as specified in its …

postgresql generate-series

PostgreSQL splitting time range into days

I'm trying to write a complex query using PostgreSQL 9.2.4, and I'm having trouble getting it working. I have a table …

sql postgresql date-range generate-series

generate_series function in Amazon Redshift

I tried the below: SELECT * FROM generate_series(2,4); generate_series ----------------- 2 3 4 (3 rows) SELECT * FROM generate_series(5,1,-2); generate_series ----------------- 5 3 1 (3 …

amazon-redshift generate-series