On Mon, Nov 02, 2009 at 10:52:40AM +0000, Jasen Betts wrote: > what's the absolute value of '1month -30 days'::interval
Curious what a use case for taking the absolute value of such mixed intervals might be. I could imagine such intervals being used for stuff like "XXX is due in Y months but needs to be submitted Z days earlier". But I can't really imagine worrying about if it's positive or negative until it's evaluated at a particular date (i.e. reporting "XXX has to be submitted in N days" or "XXX was supposed to be submitted N days ago"). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
