Re: Bug in AdjustIntervalForTypmod function

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Sent: Tuesday, May 13, 2003 6:44 PM
Subject: Re: [BUGS] Bug in AdjustIntervalForTypmod function

> "Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> > ERROR: AdjustIntervalForTypmod(): internal coding error
>
> You passed it a typmod that's illegal for INTERVAL, viz 0.

Having executed thus:
Bugs=>SELECT '7 Days'::interval(7);
ERROR: INTERVAL(7) precision must be between 0 and 6

I assumed that the typmod for the interval_in function was in the above range.
Sorry about that.

Thanks
Donald.