Re: 7.3 interval casting broken (7.4 OK)

Does this affect all versions of 7.3?

John Griffiths

Tom Lane wrote:

>>----------
>>From:     Tom Lane[SMTP:TGL@SSS.PGH.PA.US]
>>Sent:     Saturday, October 18, 2003 3:14:37 PM
>>To:     elein
>>Cc:     pgsql-bugs@postgresql.org
>>Subject:     Re: [BUGS] 7.3 interval casting broken (7.4 OK)
>>Auto forwarded by a Rule
>>
>>
>>
>elein <elein@varlena.com> writes:
>
>
>>The interval casting in 7.3 is ignoring precision.
>>
>>
>
>Yeah, see this fix:
>
>2003-01-08 19:58  tgl
>
>    * src/include/catalog/pg_proc.h: Add missing pg_proc entry for
>    interval_scale().  The lack of this entry causes interval rounding
>    not to work as expected in 7.3, for example SELECT
>    '18:17:15.6'::interval(0) does not round the value.  I did not
>    force initdb, but one is needed to install the added row.
>
>We couldn't back-patch that into 7.3 without an initdb, unfortunately.
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>