"Michal Pasternak" <michal(dot)dtz(at)gmail(dot)com> writes:
> Please add a divide operator for INTERVAL type, if possible.
Given that intervals have multiple subfields, it's far from obvious
what division should mean. What is '1 month' / '1 day'?
> db=# SELECT EXTRACT(EPOCH FROM '15 seconds'::INTERVAL) / EXTRACT(EPOCH FROM
> '15 seconds'::INTERVAL);
If that's the behavior you want, you already have a way to do it
(and you could wrap that up in a user-defined operator if you chose).
It loses quite a lot of information though, so I doubt we'd want
to enshrine it as the standard definition.
regards, tom lane