Adrian Klaver schrieb am 05.02.2017 um 22:40: >> I just stumbled about a report that has been running for a long time now >> and that relied on the fact that the interval "timestamp - timestamp" >> always returns an interval with days, hours, minutes. But never a >> "justified" interval with years, months, days and so on. > > According to the docs: > > https://www.postgresql.org/docs/9.6/static/functions-datetime.html > > "Subtraction of date or timestamp values with the "-" operator returns the number of days (24-hours) and hours/minutes/seconds between the values, making the same adjustments." > > It should always return days and hours. Ah, great. For some reason I didn't find that. >> The query usees "extract(day from timestamp - timestamp)" which is >> working fine, but would apparently fail if a justified interval was >> returned > > Did that happen? No it didn't. I just was curious if I relied on something that might change. Thanks -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
