Tom Lane wrote:
>"Stephen R. van den Berg" <[EMAIL PROTECTED]> writes:
>> Intervals are a scalar, not an addition of assorted values, alternating signs
>> between fields would be wrong.
>Sorry, you're the one who's wrong on that. We've treated intervals as
>three independent fields for years now
Tom Lane wrote:
"Stephen R. van den Berg" <[EMAIL PROTECTED]> writes:
Intervals are a scalar, not an addition of assorted values, alternating signs
between fields would be wrong.
Sorry, you're the one who's wrong on that. We've treated intervals as
three independent fields for years now (and
"Stephen R. van den Berg" <[EMAIL PROTECTED]> writes:
> Intervals are a scalar, not an addition of assorted values, alternating signs
> between fields would be wrong.
Sorry, you're the one who's wrong on that. We've treated intervals as
three independent fields for years now (and before that it w
Tom Lane wrote:
>Ron Mayer <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>> If I read SQL 200N's spec correctly
>> select interval '-1 1:00:00';
>> should mean"-1 days -1 hours",
>> yet 8.3 sees it as "-1 days +1 hours".
>I think we are kind of stuck on this one. If we change it, the
Tom Lane wrote:
If I read SQL 200N's spec correctly
select interval '-1 1:00:00';
should mean"-1 days -1 hours",
yet 8.3 sees it as "-1 days +1 hours".
I think we are kind of stuck on this one. If we change it, then how
would one represent -1 days +1 hours? The spec's format is only
Ron Mayer <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hmm. I'm a bit concerned about possible side-effects on other cases:
>> what had been seen as two separate tokens will now become one token
>> for *all* datetime types, not just interval. However, I can't
> If it's a concern, I could mak
Tom Lane wrote:
Ron Mayer <[EMAIL PROTECTED]> writes:
Short summary:
I think this patch fixes a bug with sql-spec negative interval literals.
Hmm. I'm a bit concerned about possible side-effects on other cases:
what had been seen as two separate tokens will now become one token
for *all* da
Ron Mayer <[EMAIL PROTECTED]> writes:
> Short summary:
> I think this patch fixes a bug with sql-spec negative interval literals.
Hmm. I'm a bit concerned about possible side-effects on other cases:
what had been seen as two separate tokens will now become one token
for *all* datetime types, no
