Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Ah. And one final question regarding functionality.
> It seems to me that the last remaining place where we input
> a SQL-2008 standard literal and do something different from
> what the standard suggests is with the string:
> '-1 2:03:04'
> The standard seems to say that the "-" affects both the
> days and hour/min/sec part; while PostgreSQL historically,
> and the patch as I first submitted it only apply the negative
> sign to the days part.
> IMHO when the IntervalStyle GUC is set to "sql_standard",
> it'd be better if the parsing of this literal matched the
Then how would you input a value that had different signs for the
day and the h/m/s? I don't think "you can't" is an acceptable
answer there, because it would mean that interval_out has to fail
on such values when IntervalStyle is "sql_standard". Which is
very clearly not gonna do.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2008-11-04 16:01:07|
|Subject: Re: [WIP] In-place upgrade|
|Previous:||From: Kevin Grittner||Date: 2008-11-04 15:57:40|
|Subject: Re: Patch for SQL-Standard Interval output anddecouplingDateStyle from IntervalStyle|