operator suggest " interval / interval = numeric"

From: "Ilya A(dot) Kovalenko" <shadow(at)oganer(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: operator suggest " interval / interval = numeric"
Date: 2008-01-09 10:33:00
Message-ID: 1824233089.20080109173300@oganer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I suggest one more standard date/time operator, to divide one interval
by another with numeric (or float, for example) result.
I.e. something like that:

database=# SELECT '5400 seconds'::interval / '1 hour'::interval;

?column?
----------
1.5
(1 row)

Ilya A. Kovalenko

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gokulakannan Somasundaram 2008-01-09 10:39:31 Some ideas about Vacuum
Previous Message Simon Riggs 2008-01-09 10:14:27 Re: [PATCHES] Archiver behavior at shutdown