Обсуждение: Release notes typo

"dates who's result" should be "dates whose result."

--
Michael Fuhr

Michael Fuhr <mike@fuhr.org> writes:
> "dates who's result" should be "dates whose result."

It's still horrible English :-(  A date hasn't got a result, much
less one that includes a daylight savings time adjustment period.
We should rewrite the entire paragraph.  Maybe

    Days that contain a daylight savings time adjustment are not 24
    hours, but typically 23 or 25 hours. This change creates a
    conceptual distinction between intervals of "so many days"
    and intervals of "so many hours".  Adding '1 day' to a timestamp
    now gives the same local time on the next day even if a daylight
    savings time adjustment occurs between, whereas adding '24 hours'
    will give a different local time when this happens.  For example:
        <same example>

            regards, tom lane

On Tue, Oct 25, 2005 at 12:17:52AM -0400, Tom Lane wrote:
> Michael Fuhr <mike@fuhr.org> writes:
> > "dates who's result" should be "dates whose result."
>
> It's still horrible English :-(  A date hasn't got a result, much
> less one that includes a daylight savings time adjustment period.

Good point.

> We should rewrite the entire paragraph.  Maybe
>
>     Days that contain a daylight savings time adjustment are not 24
>     hours, but typically 23 or 25 hours. This change creates a
>     conceptual distinction between intervals of "so many days"
>     and intervals of "so many hours".  Adding '1 day' to a timestamp
>     now gives the same local time on the next day even if a daylight
>     savings time adjustment occurs between, whereas adding '24 hours'
>     will give a different local time when this happens.  For example:

Sounds reasonable.

BTW, I don't know what's correct in other countries, but in the US
it's officially "daylight saving time" (singular "saving").

http://tf.nist.gov/general/daylightsavingtime.html

Not that anybody actually says it that way ;-)

--
Michael Fuhr
(Who'd be happy to live on UTC and do away with timezones and DST altogether.)

I updated the description differently:

        Dates that contain a daylight savings time adjustment are not 24
        hours, but typically 23 or 25 hours. This change allows numeric days
        (not fixed 24-hour periods) to be added to dates which include
        a daylight savings time adjustment period. Therefore, while in
        previous releases <literal>1 day</> and <literal>24 hours</> were
        interchangeable interval values, in this release they are treated
        differently, e.g.

---------------------------------------------------------------------------

Michael Fuhr wrote:
> "dates who's result" should be "dates whose result."
>
> --
> Michael Fuhr

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073