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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
