On 5/21/06, Brendan Jurd <direvus@xxxxxxxxx> wrote:
Well if you're willing to accept that for the purposes of computing the
aggregates, an interval "month" is equal to 30 days (which is how
avg(interval) already works), then an interval is reducable to a single
quantity -- a number of seconds -- which can be squared.
Let me make a correction. Internally, intervals are stored as separate
values of months and days (and even seconds, for daylight saving
purposes). So, in almost all cases everything is OK. But it isn't so
when we should multiply or devide such 'hetorogenious intevals'
("select interval '1 month 1 day';" gives us '15 days 12:00:00')...
--
Best regards,
Nikolay
