Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle

Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Tom Lane wrote:
>> There isn't any way to do that, unless you have a time machine in
>> your hip pocket. The trouble with putting
>> set intervalstyle = something;
>> into the dump script is that older servers will (by default) report
>> an error on that line and keep right on chugging.

> Not necessarily. Couldn't we put

> select * from (select substring(version() from '[0-9\.]+') as version) as a
> join (select generate_series(0,100000000000)) as b on(version<'8.4');
> set intervalstyle = something;

> Or something similar in the dump file.

[ shrug... ] It's still just one easily missable bleat.

regards, tom lane