Re: No stddev() for interval?

From: "Ivan Zolotukhin" <ivan(dot)zolotukhin(at)gmail(dot)com>
To: nikolay(at)samokhvalov(dot)com
Cc: "Brendan Jurd" <direvus(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: No stddev() for interval?
Date: 2006-05-20 22:31:44
Message-ID: 751e56400605201531g77f1cb46xcb66be93fdd11d46@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/21/06, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> wrote:
> 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')...

You obviously meant "select interval '1 month 1 day' / 2;" to get
above weird result of 15 days and 12 hours.

Regards,
Ivan Zolotukhin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2006-05-20 23:37:52 Re: Read Write
Previous Message Nikolay Samokhvalov 2006-05-20 22:21:51 Re: No stddev() for interval?