Re: [SQL] create function problem

2010-12-30 Thread Gary Stainburn
On Thursday 30 December 2010 17:47:09 Adrian Klaver wrote: > To follow up I think the OP was looking for ELSEIF not ELSE IF. Changing > the ELSE IF to ELSEIF should fix it. > Thanks guys. That'll teach me to read tutorials more carefully. -- Gary Stainburn I.T. Manager Ringways Garages http://www

Re: [SQL] create function problem

2010-12-30 Thread Adrian Klaver
On 12/30/2010 09:35 AM, Pavel Stehule wrote: Hello you badly use a IF statement. It's not C. Every IF must to finish with END IF this is IF .. THEN ELSEIF .. THEN .. ELSE END IF Regards Pavel Stehule To follow up I think the OP was looking for ELSEIF not ELSE IF. Changing the ELSE IF to E

Re: [SQL] create function problem

2010-12-30 Thread Pavel Stehule
Hello you badly use a IF statement. It's not C. Every IF must to finish with END IF this is IF .. THEN ELSEIF .. THEN .. ELSE END IF Regards Pavel Stehule 2010/12/30 Gary Stainburn : > Hi folks, > > I'm writing my first plpsql function in ages and I'm going blind trying to see > why it won't