I expect 0 because
SELECT EXTRACT(YEAR FROM INTERVAL '1 day'), EXTRACT(MONTH FROM INTERVAL '1
day')
returns 0,0
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eugene M. Hutorny" <[EMAIL PROTECTED]>
Cc: <pgsql-bugs@postgresql.org>
Sent: Friday, September 21, 2007 7:21 PM
Subject: Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns
1
"Eugene M. Hutorny" <[EMAIL PROTECTED]> writes:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
> Returns: 1
> Expected: 0
Why would you expect that? Quarters are numbered 1 through 4.
And it doesn't "always return 1":
regression=# SELECT EXTRACT(QUARTER FROM INTERVAL '3 months');
date_part
-----------
2
(1 row)
regression=# SELECT EXTRACT(QUARTER FROM INTERVAL '11 months');
date_part
-----------
4
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
