Re: [BUGS] 7.3 interval casting broken (7.4 OK)

[John Griffiths]

Does this affect all versions of 7.3?

John Griffiths

Tom Lane wrote:

----------
From: 	Tom Lane[SMTP:[EMAIL PROTECTED]
Sent: 	Saturday, October 18, 2003 3:14:37 PM
To: 	elein
Cc: 	[EMAIL PROTECTED]
Subject: 	Re: [BUGS] 7.3 interval casting broken (7.4 OK) 
Auto forwarded by a Rule

   

elein <[EMAIL PROTECTED]> 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
 



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])