Jørn Cornelius Olsen ([EMAIL PROTECTED]) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
pgplsql: IF-THEN-ELSIF-ELSE acts different from IF-THEN-ELSE IF
Long Description
1) The 'boolean-expression' after 'ELSIF' always evaluates to FALSE. According to the
manual IF-THEN-ELSIF-ELSE should be formally equivalent to IF-THEN-ELSE-IF-THEN, yet
the example code below shows differently.
2) Also: There is no parse error if one omits 'THEN' after 'ELSIF boolean-expression'
which leads me to believe that ELSIF has never been implemented. Yet there is not
warning or error message nor any notices in the documentation.
Apart from the above: Thanks for a great SQL!
Sample Code
*** For the record ***
select version();
version
-------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
*** Demonstration ***
> create function demo1() returns integer as '
begin
if false then
return 1;
elsif true then
return 2;
else
return 3;
end if;
end;' language 'plpgsql';
> select demo1();
demo1
-------
3
(1 row)
create function demo2() returns integer as '
begin
if false then
return 1;
else
if true then
return 2;
else
return 3;
end if;
end if;
end;' language 'plpgsql';
> select demo2();
demo2
-------
2
(1 row)
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
