On May 16, 2009, at 11:58 PM, Brendan Jurd <dire...@gmail.com> wrote:
On Sun, May 17, 2009 at 1:40 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
"Dickson S. Guedes" <lis...@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?
It appears that any generate_series involving infinity is guaranteed
to fail.
That being the case, wouldn't it be more useful to throw an error than
to just keep on running until overflow?
What if it were combined with LIMIT?
...Robert
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
