Re: Bug in AdjustIntervalForTypmod function

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


> "Donald Fraser" <demolish@cwgsy.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.