Re: Casting from a domain - Mailing list pgsql-general

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