Márcio A. Sepp wrote:
> 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;
> 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?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services