Re: Patch for SQL-standard negative valued year-month literals

From: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Patch for SQL-standard negative valued year-month literals
Date: 2008-09-17 15:19:35
Message-ID: 20080917151935.GA10689@cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>"Stephen R. van den Berg" <srb(at)cuci(dot)nl> 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 was two
>independent fields).

Ok, didn't know that.
Let's put it differently then: I can understand that the standard
considers it a scalar and not an addition, but apparently the addition
characteristic is being used in Postgres code already; that makes it
undesirable to change it indeed.
--
Sincerely,
Stephen R. van den Berg.

He did a quarter of the work in *half* the time!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2008-09-17 15:31:45 Re: Column level privileges was:(Re: Extending grant insert on tables to sequences)
Previous Message Tatsuo Ishii 2008-09-17 15:05:13 Re: Common Table Expressions (WITH RECURSIVE) patch