List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:December 7 2006 1:00pm
Subject:Re: Function problem
View as plain text  
> Can somebody tells what's wrong with this fuction?

I guess that depends on what it should do, wouldn't it?

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
 
>  
> 
> DELIMITER $$
> 
>  
> 
> DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$
> 
>  
> 
> CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2)
> 
> BEGIN
> 
> CASE x 
> 
> WHEN x<50 THEN ceiling(x+x*0.25)
> 
> when x>=50 AND x<100 then ceiling(x+x*0.20)
> 
> when x>=100 AND x<150 then ceiling(x+x*0.15)
> 
> when (x>=150 AND x<200) then (ceiling(x+x*0.10)) 
> 
> when (x>=200) then (ceiling(x+x*0.09)) 
> 
> end case;
> 
> END$$
> 
>  
> 
> DELIMITER ;
> 
>  
> 
> Thanx
> 
> Nikos
> 
>  
> 
> 
Thread
Function problemnikos7 Dec
  • Re: Function problemMartijn Tonies7 Dec
  • Re: Function problemChris White7 Dec
    • RE: Function problemnikos8 Dec