From: | "Eugene Hutorny" <eugene(at)ksf(dot)kiev(dot)ua> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1 |
Date: | 2007-09-21 17:08:59 |
Message-ID: | 004d01c7fc72$1d56d650$82a8a8c0@ksf |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eugene M. Hutorny" <eugene(at)ksf(dot)kiev(dot)ua>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Friday, September 21, 2007 7:21 PM
Subject: Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns
1
"Eugene M. Hutorny" <eugene(at)ksf(dot)kiev(dot)ua> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-09-21 17:14:03 | Re: CREATE USER and createuser not working the same |
Previous Message | Tom Lane | 2007-09-21 16:21:44 | Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1 |