Jim C. Nasby wrote:
> 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