----- 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.