decibel=# create cast (interval as rrs.seconds) WITH FUNCTION rrs.interval_to_seconds(interval) AS IMPLICIT;^^^
decibel=# select cast('1 month'::interval AS seconds);
ERROR: cannot cast type interval to seconds
It's not a schema issue is it? I.E. the lack of "rrs."?
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
