Re: generate_series from now to infinity... - Mailing list pgsql-hackers

"Dickson S. Guedes" <listas@guedesoft.net> writes:
> Is a simple "SELECT generate_series(now(), CAST('infinity'::date AS
> timestamp), interval '1 hour');" working forever, an expected
> behavior?

Uh, what were you expecting it to do?

Actually, I believe it will fail eventually when the repeated additions
overflow ... in 294277 AD.  So you've got about 2 billion timestamp
additions to wait through.
        regards, tom lane