Re: [COMMITTERS] pgsql: PL/Python: Convert numeric to Decimal

Look at that:
 return x $$ LANGUAGE plpythonu; SELECT * FROM test_type_conversion_numeric(100);
! INFO:  (Decimal('100'), 'Decimal') CONTEXT:  PL/Python function "test_type_conversion_numeric"
test_type_conversion_numeric------------------------------
 
--- 219,225 ---- return x $$ LANGUAGE plpythonu; SELECT * FROM test_type_conversion_numeric(100);
! INFO:  (Decimal("100"), 'Decimal') CONTEXT:  PL/Python function "test_type_conversion_numeric"
test_type_conversion_numeric------------------------------
 

" instead of '

All the more reason to use as_tuple



On Sat, Jul 6, 2013 at 9:16 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>
> On 07/06/2013 01:52 AM, Claudio Freire wrote:
>>
>> On Sat, Jul 6, 2013 at 2:39 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>
>>> Peter Eisentraut <peter_e@gmx.net> writes:
>>>>
>>>> PL/Python: Convert numeric to Decimal
>>>
>>> Assorted buildfarm members don't like this patch.
>>
>>
>> Do you have failure details?
>>
>> This is probably an attempt to operate decimals vs floats.
>>
>> Ie: Decimal('3.0') > 0 works, but Decimal('3.0') > 1.3 doesn't
>> (decimal is explicitly forbidden from operating on floats, some design
>> decision that can only be disabled in 3.3).
>>
>>
>
>
> Instead of speculating, you can actually see for yourself. The dashboard is
> at <http://www.pgbuildfarm.org/cgi-bin/show_status.pl> Pick one of the
> machines failing at PLCheck-C and click its 'Details' link. Then scroll down
> a bit and you'll see what is failing.
>
> cheers
>
> andrew
>