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/