| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, pablopumarino(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14294: Problem in generate series between dates |
| Date: | 2016-08-31 15:37:37 |
| Message-ID: | 20160831153737.xubrne5yzfedscym@msg.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Re: Tom Lane 2016-08-24 <31168(dot)1472069440(at)sss(dot)pgh(dot)pa(dot)us>
> In other words, we could make this scenario "work" if we defined
> generate_series as base plus N times the increment, rather than as
> repeated addition of the increment. But I wouldn't be surprised
> if that would break other corner cases (and it would certainly
> be slower). Daylight-savings time is not one of the more consistent
> things in our world ... not that anything at all about the civil
> calendar is mathematically nice :-(.
To avoid DST problems, wouldn't a "date"-based generate_series be the
safe way to go?
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2016-08-31 17:41:06 | Re: BUG #14302: SQL with LIMIT degrades performance seriously |
| Previous Message | Francisco Olarte | 2016-08-31 13:58:58 | Re: BUG #14302: SQL with LIMIT degrades performance seriously |