On Thu, 2009-10-29 at 16:39 -0700, Scott Bailey wrote: > But there is some ambiguity around the length of a month. So INTERVAL '1 > month - 30 days' = INTERVAL '0 days' = INTERVAL '-1 month +30 days'. > But when added to a date, it makes no change for months with 30 days, > adds 1 day for months with 31 days and subtracts 2 days for February. Yes, that is a strange case. When you can't tell if an interval is positive or negative, how do you define the absolute value? I think that's a strong argument not to provide an absolute value function for INTERVALs. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
