Re: [SQL] Interval subtracting

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [SQL] Interval subtracting
Date: 2006-03-02 06:45:52
Message-ID: 1141281952.3737.17.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe:

> > But it isn't '-2 months, -1 day'. I think what you are saying is what I
> > am saying, that we should make the signs consistent.
>
> Pretty much. It just seems wrong to have different signs in what is
> essentially a single unit.
>
> We don't say 42 degrees, -12 minutes when measuring arc, do we? Then
> again, maybe some folks do. It just seems wrong to me.

But we do say both "quarter past three" (3 hours 15 min) and "quarter to
four" (4 hours -15 min) when talking about time.

---------------
Hannu

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-02 06:52:49 Re: Automatic free space map filling
Previous Message Tom Lane 2006-03-02 06:01:21 Re: Automatic free space map filling

Browse pgsql-patches by date

  From Date Subject
Next Message Tino Wildenhain 2006-03-02 07:05:11 Re: [SQL] Interval subtracting
Previous Message Mark Dilger 2006-03-02 01:18:12 Re: [SQL] Interval subtracting

Browse pgsql-sql by date

  From Date Subject
Next Message Tino Wildenhain 2006-03-02 07:05:11 Re: [SQL] Interval subtracting
Previous Message Tom Lane 2006-03-02 06:16:47 Re: Change date format through an environmental variable?