Postgres Pro
Downloads
Home   >   mailing lists

Re: operator suggest " interval / interval = numeric" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: operator suggest " interval / interval = numeric"
Date
Msg-id 5774.1199891868@sss.pgh.pa.us
Whole thread Raw
In response to operator suggest " interval / interval = numeric"  ("Ilya A. Kovalenko" <shadow@oganer.net>)
Responses Re: operator suggest " interval / interval = numeric"  ("Warren Turkal" <wturkal@gmail.com>)
Re: operator suggest " interval / interval = numeric"  ("Brendan Jurd" <direvus@gmail.com>)
List pgsql-hackers
Tree view 
"Ilya A. Kovalenko" <shadow@oganer.net> writes:
> I suggest one more standard date/time operator, to divide one interval
> by another with numeric (or float, for example) result.

You'd have to define exactly what that means, which seems a little
tricky for incommensurate intervals.  For instance what is the
result of '1 month' / '1 day' ?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Archiver behavior at shutdown
Next
From: Markus Schiltknecht
Date:
Subject: Re: Named vs Unnamed Partitions