On Sat, Mar 6, 2010 at 2:12 AM, Chris Travers wrote:
> On Fri, Mar 5, 2010 at 2:32 PM, Tom Lane wrote:
> > Robert Haas writes:
> >>> On Wed, Mar 3, 2010 at 9:53 PM, Robert Haas
> wrote:
> >>> It does seem weird that assigning NEW to var changes the value; I'm
> >>> not sure why that happens. I
All,
I tested Noel's test case and verified that it does, in fact, break.
And functions on 8.4.
--Josh Berkus
Original Message
Subject: [TESTERS] Numerics of diffrent scales Raises Type Mismatch
Error in a Set Returning Function
Date: Tue, 2 Mar 2010 20:07:07 -0800
From: Noel P
Josh Berkus writes:
> I tested Noel's test case and verified that it does, in fact, break.
> And functions on 8.4.
This is an intentional change, as the previous behavior is obviously
wrong. Try putting in a value that does not conform to numeric(14,2),
such as 42.. It doesn't get converted
Robert Haas wrote:
> On Fri, Mar 5, 2010 at 3:52 AM, Thomas Kellerer
> wrote:
> > Thanks for the feedback.
> >
> > Is the problem specific to 8.4.2 or to the Windows platform (or both)?
>
> Neither, actually.
The fix will be in the next minor Postgres release. Keep an eye out for
it when it is
