From: | John Griffiths <griffithsjr(at)navair(dot)navy(dot)mil> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: 7.3 interval casting broken (7.4 OK) |
Date: | 2003-10-20 11:45:52 |
Message-ID: | 3F93CAF0.4060408@navair.navy.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Does this affect all versions of 7.3?
John Griffiths
Tom Lane wrote:
>>----------
>>From: Tom Lane[SMTP:TGL(at)SSS(dot)PGH(dot)PA(dot)US]
>>Sent: Saturday, October 18, 2003 3:14:37 PM
>>To: elein
>>Cc: pgsql-bugs(at)postgresql(dot)org
>>Subject: Re: [BUGS] 7.3 interval casting broken (7.4 OK)
>>Auto forwarded by a Rule
>>
>>
>>
>elein <elein(at)varlena(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | CN | 2003-10-21 04:09:30 | Contraints problem in PLPGSQL |
Previous Message | Tom Lane | 2003-10-18 19:14:37 | Re: 7.3 interval casting broken (7.4 OK) |