Обсуждение: Release notes typo
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