From: | Márcio A(dot) Sepp <marcio(at)zyontecnologia(dot)com(dot)br> |
---|---|
To: | "'Alvaro Herrera'" <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | RES: help with generation_series in pg10 |
Date: | 2018-01-09 16:14:46 |
Message-ID: | 00ee01d38964$f7bfbf70$e73f3e50$@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');
in some case I need to order the timestamp data field and in others I just
need an interval. So, in some moments an random data already help me and in
others it is necessary to have both fields aligned.
thanks
From | Date | Subject | |
---|---|---|---|
Next Message | John McKown | 2018-01-09 16:17:41 | Re: Getting started with first user. |
Previous Message | Jaime Soler | 2018-01-09 16:14:21 | Re: Getting started with first user. |