| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | "Adriaan van Os" <postgres(at)microbizz(dot)nl> |
| Subject: | Re: BUG #2977: dow doesn't conform to ISO-8601 |
| Date: | 2007-02-07 10:57:21 |
| Message-ID: | 200702071157.22498.peter_e@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
Am Mittwoch, 7. Februar 2007 11:24 schrieb Adriaan van Os:
> Section 9.9.1 of the Postgres docs
> <http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html>
> 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 ?
They don't.
> 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".)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Grigorovich | 2007-02-07 11:42:37 | BUG #2979: Functional indexes ERROR while updating table |
| Previous Message | Adriaan van Os | 2007-02-07 10:24:49 | BUG #2977: dow doesn't conform to ISO-8601 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-02-07 12:41:41 | Re: [PATCHES] Fix "database is ready" race condition |
| Previous Message | Gregory Stark | 2007-02-07 10:49:17 | LIMIT/SORT optimization |