Why do some of the intervals show days broken out whereas others only show hours? I have seen intervals left in hours even when the intervals are more than two days long. FWIW, I would prefer if it was always left in hours, but would be happy if it would just be consistent either way.
I have the same issue on 8.4. Fixing it is low on my task list, but I too would like to know why.
An interim fix might be to cast your output to interval(0) (or to whatever degree of precision you might need). I believe I encountered this behavior some time ago and casting solved the problem for me. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
