Re: [BUGS] BUG #1217: wrong date->number of week conversion

2004-08-14 Thread Peter Eisentraut
Jean-Luc Lachance wrote: > This look like it would be nice to have it configurable. > > first_day_of_the_week > first_day_of the_year Well, this isn't really negotiable. You can define your own calendar functions that do this, but the standard ones need to be left alone. This standard isn't ju

Re: [BUGS] BUG #1217: wrong date->number of week conversion

2004-08-13 Thread Jean-Luc Lachance
This look like it would be nice to have it configurable. first_day_of_the_week first_day_of the_year Tom Lane wrote: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: Frankly speaking I don`t know the adequate calendar ISO norm in detail, but the last days of year shouldn`t be counted as F_I_R_

Re: [BUGS] BUG #1217: wrong date->number of week conversion

2004-08-12 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Frankly speaking I don`t know the adequate calendar ISO norm in detail, but > the last days of year shouldn`t be counted as F_I_R_S_T week of that year. I > expected PostgreSQL rather to return 2003-53-29. You are mistaken. The ISO week is

[BUGS] BUG #1217: wrong date->number of week conversion

2004-08-12 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1217 Logged by: Romuald Pilitowski Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Mandrake 10.0 Description:wrong date->number of week conversion Details: hi, I encount