Skip site navigation (1) Skip section navigation (2)

Re: BUG #2977: dow doesn't conform to ISO-8601

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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/

In response to

Responses

pgsql-bugs by date

Next:From: Roman GrigorovichDate: 2007-02-07 11:42:37
Subject: BUG #2979: Functional indexes ERROR while updating table
Previous:From: Adriaan van OsDate: 2007-02-07 10:24:49
Subject: BUG #2977: dow doesn't conform to ISO-8601

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-02-07 12:41:41
Subject: Re: [PATCHES] Fix "database is ready" race condition
Previous:From: Gregory StarkDate: 2007-02-07 10:49:17
Subject: LIMIT/SORT optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group