Re: Issues with generate_series using integer boundaries
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Thom Brown <thom(at)linux(dot)com>
Cc:
PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject:
Re: Issues with generate_series using integer boundaries
Date:
2011-02-01 00:36:42
Message-ID:
11684.1296520602@sss.pgh.pa.us (view raw or flat )
Thread:
2011-02-01 00:15:06 from Thom Brown <thom(at)linux(dot)com>
2011-02-01 00:33:27 from Thom Brown <thom(at)linux(dot)com>
2011-02-01 00:36:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-01 00:41:25 from Thom Brown <thom(at)linux(dot)com>
2011-02-01 00:48:13 from Thom Brown <thom(at)linux(dot)com>
2011-02-09 01:50:06 from Glenn Maynard <glenn(at)zewt(dot)org>
2011-02-01 01:05:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-01 02:17:17 from Thom Brown <thom(at)linux(dot)com>
2011-02-01 20:26:34 from Thom Brown <thom(at)linux(dot)com>
2011-02-01 21:32:52 from Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
2011-02-01 23:08:55 from Thom Brown <thom(at)linux(dot)com>
2011-02-03 11:31:01 from Thom Brown <thom(at)linux(dot)com>
2011-02-03 11:34:45 from Thom Brown <thom(at)linux(dot)com>
2011-02-03 13:32:51 from Thom Brown <thom(at)linux(dot)com>
2011-02-03 13:58:04 from Thom Brown <thom(at)linux(dot)com>
2011-02-03 14:37:10 from "David Johnston" <polobo(at)yahoo(dot)com>
2011-02-03 14:43:09 from Thom Brown <thom(at)linux(dot)com>
2011-02-04 12:32:33 from Thom Brown <thom(at)linux(dot)com>
2011-02-07 09:04:15 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-02-07 11:38:09 from Thom Brown <thom(at)linux(dot)com>
2011-02-08 09:22:18 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-02-08 10:12:47 from Thom Brown <thom(at)linux(dot)com>
2011-02-09 01:17:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-09 01:19:11 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-02-09 01:30:26 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-09 02:11:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-09 09:50:09 from Thom Brown <thom(at)linux(dot)com>
2011-06-17 03:44:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-06-17 14:22:33 from Thom Brown <thom(at)linux(dot)com>
2011-06-17 14:39:04 from "David Johnston" <polobo(at)yahoo(dot)com>
2011-06-17 14:45:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-06-17 18:15:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-06-17 18:40:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-06-17 18:52:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-general pgsql-hackers
Thom Brown <thom(at)linux(dot)com> writes:
> Actually, those lower bound errors aren't related to generate_series,
> but I'd still like to know why -2147483648::int4 is out of range.
:: binds tighter than - (and everything else too). Write
(-2147483648)::int4 instead.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Thom BrownDate: 2011-02-01 00:41:25Subject : Re: Issues with generate_series using integer boundariesPrevious :From : Tom LaneDate : 2011-02-01 00:33:32Subject : Re: Error code for "terminating connection due to conflict with recovery"
pgsql-general by date
Next :From: Thom BrownDate: 2011-02-01 00:41:25Subject : Re: Issues with generate_series using integer boundariesPrevious :From : Thom BrownDate : 2011-02-01 00:33:27Subject : Re: Issues with generate_series using integer boundaries
