Re: [BUGS] BUG #2714: Wrong Result with static number

2006-10-26 Thread Tom Lane
"Frank Schmidt" <[EMAIL PROTECTED]> writes: > But when I change the Statement "BD1.Einzelpreis * (1 - Rabatt) as > decimal(8,2))>= " to a static number (like 5) no result will be generated. > SELECT DISTINCT Artikelname, cast(BD1.Einzelpreis * (1 - Rabatt) as > decimal(8,2)) AS Preis, Rabatt > FRO

[BUGS] BUG #2714: Wrong Result with static number

2006-10-26 Thread Frank Schmidt
The following bug has been logged online: Bug reference: 2714 Logged by: Frank Schmidt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Windows Description:Wrong Result with static number Details: Follow skript works fine: SELECT DISTINC