Re: pl/pgsql oddity

Tomasz Myrta zei:
>> 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
>> return ''>= 38'';
>> else
>> return ''this is not possible'';
>> end if;
>> end;'
>> language 'plpgsql';
>> -------------------------------------------------------
>>
>> But I can't understand or solve it. The function always returns
>> 'this is not possible'. Can someone tell me what I'm overlooking?
>> Thanks!
>
> Documentation says you should use "elsif" rather than "elseif". In
> your
> case everything between "return <38" and "else" is discarded as
> unreachable code.

That's it, thanks!