Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1 - Mailing list pgsql-bugs

Am Freitag, 21. September 2007 schrieb Eugene M. Hutorny:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
>
> Returns: 1
> Expected: 0
>       Or: ERROR: interval units "quarter" not supported

An alternative behavior would be to return something like

 ceil($argument / (360/4))

or however one would calculate the quarter exactly.

The current behavior makes no sense to me either.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/