interval / interval -> double operator

Поиск
Список
Период
Сортировка
От Andrew Hammond
Тема interval / interval -> double operator
Дата
Msg-id 1179441957.460862.166380@p77g2000hsh.googlegroups.com
обсуждение
Ответы Re: interval / interval -> double operator
Список pgsql-hackers
Yet another potential addition to the family of operators. Some guy
was asking for it on IRC so...

CREATE OR REPLACE FUNCTION interval_over_interval(interval, interval)
RETURNS float STRICT IMMUTABLE LANGUAGE sql AS $$
SELECT extract(epoch from $1)::float / extract(epoch from $2);
$$;

CREATE OPERATOR /
(   leftarg = interval
,   rightarg = interval
,   procedure = interval_over_interval
);



В списке pgsql-hackers по дате отправления: