RES: help with generation_series in pg10

From: Márcio A(dot) Sepp <marcio(at)zyontecnologia(dot)com(dot)br>
To: "'Merlin Moncure'" <mmoncure(at)gmail(dot)com>
Cc: "'Alvaro Herrera'" <alvherre(at)alvh(dot)no-ip(dot)org>, "'pgsql-general'" <pgsql-general(at)postgresql(dot)org>
Subject: RES: help with generation_series in pg10
Date: 2018-01-10 15:22:07
Message-ID: 005801d38a26$c7068540$55138fc0$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >> > how can i have the same in pg10 as i have had in pg 9.x?
> >>
> >> Move the function call to the FROM clause:
> >>
> >> select g, (g - 1) % 5 + 1 from generate_series(1, 10) g;
> >
> > thank you. That is exact what i need.
> >
> >
> >> > I need it to date type to... if possible.
> >>
> >> There is a generate_series() variant that can return dates (more
> >> precisely, timestamp with time zone). But what exactly would you
> >> like returned?
> >
> > In the past i use querys like this to generate some timestamp field:
> > select generate_series (1, 10), generate_series('2018-01-01
> > 10:00'::timestamp, '2018-01-02 10:00'::timestamp, '10 hours');
>
> With the old behavior you're lucky this ever worked at all. Doing this
> kind of stuff, you want to write it with a single generate_series
> driver if you can or as a cross product:
>
> select
> a, b,c
> from generate_series(1,3) a
> cross join generate_series(1,4) b
> cross join generate_series(1,2) c;

Exactly what I need. Thank you so much!!!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-01-10 15:25:10 Re: String comparison problem in select - too many results
Previous Message Merlin Moncure 2018-01-10 14:28:44 Re: help with generation_series in pg10