Re: How to do this ?

[Roland Bouman]

Beat, I don't think thats true. convince yourself:

mysql> create procedure noblock()
-> begin
-> if true then
-> select 1;
-> select 2;
-> else
-> select 3;
-> select 4;
-> end if;
-> end;
-> //
Query OK, 0 rows affected (0.06 sec)

mysql> call noblock();
-> //
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.02 sec)

+---+
| 2 |
+---+
| 2 |
+---+
1 row in set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

It works for case too.

MS SQL Transact SQL does have this restriction I believe (at least for the WHILE construct)