Am Mittwoch, 7. Februar 2007 11:24 schrieb Adriaan van Os:
> Section 9.9.1 of the Postgres docs
> mentions that the "week" subfield of the date_part function conforms to the
> ISO-8601 standard.
I see no such claim there.
> You can not, in the same function, ignore ISO-8601 for one subfield and
> follow it in another.
I think we have pretty well shown that we can.
> Besides, if in the same week Sunday comes before Monday, how can the result
> of the "week" and "dow" fields conform to each other ?
> If "dow" can not be changed for reasons of backward compatibility, I
> suggest a new subfield "dayofweek" that does conform to the standard.
That might be reasonable. (Or maybe "isodow".)
In response to
pgsql-bugs by date
|Next:||From: Roman Grigorovich||Date: 2007-02-07 11:42:37|
|Subject: BUG #2979: Functional indexes ERROR while updating table|
|Previous:||From: Adriaan van Os||Date: 2007-02-07 10:24:49|
|Subject: BUG #2977: dow doesn't conform to ISO-8601|
pgsql-patches by date
|Next:||From: Alvaro Herrera||Date: 2007-02-07 12:41:41|
|Subject: Re: [PATCHES] Fix "database is ready" race condition|
|Previous:||From: Gregory Stark||Date: 2007-02-07 10:49:17|
|Subject: LIMIT/SORT optimization|