Re: [BUGS] BUG #2242: Inconsistent casting in query with literal vs query with parameter

2006-02-07 Thread Tom Lane
"Matthew Bellew" <[EMAIL PROTECTED]> writes: > In the script below, I'd expect all four queries to return 10 rows > (1,2,3,4,5,10,20,30,40,50). However, function bystr() returns two rows > (1,10). Clearly, in this one case the query processor is casting the column > to the parameter type, rather

[BUGS] BUG #2242: Inconsistent casting in query with literal vs query with parameter

2006-02-06 Thread Matthew Bellew
The following bug has been logged online: Bug reference: 2242 Logged by: Matthew Bellew Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: XP SP2 Description:Inconsistent casting in query with literal vs query with parameter Details: In the