List:General Discussion« Previous MessageNext Message »
From:nikos Date:December 7 2006 12:57pm
Subject:Function problem
View as plain text  
Hello list.

 

Can somebody tells what's wrong with this fuction?

 

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