Postgres Pro
Downloads
Home   >   mailing lists

Re: No stddev() for interval? - Mailing list pgsql-general

From Ivan Zolotukhin
Subject Re: No stddev() for interval?
Date
Msg-id 751e56400605201531g77f1cb46xcb66be93fdd11d46@mail.gmail.com
Whole thread Raw
In response to Re: No stddev() for interval?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
List pgsql-general
Tree view 
On 5/21/06, Nikolay Samokhvalov <samokhvalov@gmail.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

pgsql-general by date:

Previous
From: "Nikolay Samokhvalov"
Date:
Subject: Re: No stddev() for interval?
Next
From: Adrian Klaver
Date:
Subject: Re: Read Write