> 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
>
>
>
>
