n***@noose.pl
2013-03-18 08:23:16 UTC
The following bug has been logged on the website:
Bug reference: 7967
Logged by: Pawel Kobylak
Email address: ***@noose.pl
PostgreSQL version: 9.1.3
Operating system: Debian
Description:
Hi,
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)
Result:
"2012-12-31";2012;1
Expected:
"2012-12-31";2012;53
OR
"2012-12-31";2013;1
This result is correct? Or that is little bug? :-)
Regards,
Pawel
Bug reference: 7967
Logged by: Pawel Kobylak
Email address: ***@noose.pl
PostgreSQL version: 9.1.3
Operating system: Debian
Description:
Hi,
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)
Result:
"2012-12-31";2012;1
Expected:
"2012-12-31";2012;53
OR
"2012-12-31";2013;1
This result is correct? Or that is little bug? :-)
Regards,
Pawel
--
Sent via pgsql-bugs mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Sent via pgsql-bugs mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs