Ian Barwick zei: > On Thu, 16 Dec 2004 10:06:19 +0100 (CET), Joolz > <[EMAIL PROTECTED]> wrote: >> Hello everyone, >> >> When writing some serverside code I ran into an oddity that I >> managed to boil down to this: >> >> ------------------------------------------------------- >> create or replace function fubar() returns varchar as ' >> declare >> l integer; >> begin >> l = 38; >> if l < 38 then >> return ''< 38''; >> elseif l >= 38 then > > Try "elsif" here. > (No, I don't know what the problem with "elseif" is).
Thanks Ian, but I don't understand... I _am_ already using elseif... ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match