Re: [BUGS] BUG #7967: Wrong week number in extract function

2013-03-18 Thread Tom Lane
no...@noose.pl writes: > I'm running that query and result is ... unexpected for me... > Query: > select '2012-12-31', EXTRACT(year from '2012-12-31'::date), EXTRACT(week > from '2012-12-31'::date) It's correct, because "week" follows the ISO definition of week counting. According to that, 2012-

Re: [BUGS] BUG #7967: Wrong week number in extract function

2013-03-18 Thread Thomas Kellerer
no...@noose.pl wrote on 18.03.2013 09:23: The following bug has been logged on the website: Bug reference: 7967 Logged by: Pawel Kobylak Email address: no...@noose.pl PostgreSQL version: 9.1.3 Operating system: Debian Description: Hi, I'm running that query and result is ..