Re: generate_series from now to infinity...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
Cc: pg-dev <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: generate_series from now to infinity...
Date: 2009-05-17 03:40:42
Message-ID: 14729.1242531642@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Dickson S. Guedes" <listas(at)guedesoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2009-05-17 03:58:41 Re: generate_series from now to infinity...
Previous Message Jignesh K. Shah 2009-05-17 03:36:04 Re: Optimizing Read-Only Scalability