Tom,
On 9/26/06 9:15 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Andrew Dunstan <[EMAIL PROTECTED]> writes:
>> ! | @ 6 years | @ 5 years 12 mons 5 days 6 hours
>
>> Doesn't this look odd regardless of what bad results come back from the
>> FP library?
>
> It looks exactly like the sort of platform-dependent rounding issue that
> Bruce and Michael Glaesemann spent a lot of time on recently. It might
> be interesting to see if CVS HEAD works any better under these
> conditions ... but if it doesn't, that doesn't mean I'll be interested
> in fixing it. Getting the float datetime code to work is hard enough
> without having a compiler that thinks it can take shortcuts.
How about fixing the compilation so that the routines in adt that are
sensitive to FP optimizations are isolated from aggressive optimization?
- Luke
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
