Skip site navigation (1) Skip section navigation (2)

Re: Numerics of diffrent scales Raises Type Mismatch Error in a Set Returning Function

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Noel Proffitt <noelp(at)calpacs(dot)org>
Cc: pgsql-testers(at)postgresql(dot)org
Subject: Re: Numerics of diffrent scales Raises Type Mismatch Error in a Set Returning Function
Date: 2010-03-07 23:08:59
Message-ID: 4B94320B.9000804@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-testers
On 3/6/10 5:10 PM, Josh Berkus wrote:
> On 3/2/10 8:07 PM, Noel Proffitt wrote:
>> [TEST REPORT]
>>
>> [Release]: 9.0 Alpha 4
>>
>> [Test Type]: feature
>>
>> [Test]: NUMERICS OF DIFFERENT SCALE UNABLE TO CAST TO RESULTS IN SET
>> RETURNING FUNCTION 
> 
> Verified as a problem in 9.0.

Per pgsql-bugs, it's an expected compatibility issue due to unifying the
SQL and PLPGSQL parsers.  That is, the fact that plpgsql used to let you
do this was regarded as a bug, and was not consistent with the SQL
command line.

Worth noting in the release notes as part of a general class of
backwards-compatibility issues.

--Josh Berkus


In response to

Responses

pgsql-testers by date

Next:From: Noel ProffittDate: 2010-03-08 06:45:22
Subject: Re: Numerics of diffrent scales Raises Type Mismatch Error in a Set Returning Function
Previous:From: Josh BerkusDate: 2010-03-07 01:10:42
Subject: Re: Numerics of diffrent scales Raises Type Mismatch Error in a Set Returning Function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group