Re: BUG #14446: make_date with negative year

Pavel Stehule wrote:
> 2016-12-04 14:40 GMT+01:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:

> > abelisto(at)gmail(dot)com wrote:
> > >
> > > with t(x) as (values('1111-11-11 BC'::date)) select
> > make_date(extract(year
> > > from x)::int, extract(month from x)::int, extract(day from x)::int) from
> > > t;
> > > ERROR: date field value out of range: -1111-11-11

So make_date was introduced in 9.4 by commit f901bb50e; this report is
based on 9.5. Do we want to backpatch this change? Since the fix only
changes behavior that currently errors out anyway, we would not be
changing anything that people are relying on. I lean towards
backpatching all the way back to 9.4 myself.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services