RE: Function problem

2006-12-08 Thread nikos
06 6:02 PM To: mysql@lists.mysql.com Subject: Re: Function problem On Thursday 07 December 2006 04:57, nikos wrote: > 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

Re: Function problem

2006-12-07 Thread Chris White
On Thursday 07 December 2006 04:57, nikos wrote: > 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)) You've declared a ret

Re: Function problem

2006-12-07 Thread Martijn Tonies
> 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 ques