PostgreSQL 怎样跳出内层循环？

[danier_sky]

for h in 0..24
loop
for m in 0..59
loop
if m > 51 then
-- 怎样跳出内层循环？
else
--.....
end if;
end loop;
end loop;

[ACMAIN_CHM]

其实如果参考一下手册，其中有很多例子如下。

[Quote]38.6.3.1. LOOP
[ <<label>> ]
LOOP
statements
END LOOP [ label ];
LOOP defines an unconditional loop that is repeated indefinitely until terminated by an EXIT or RETURN statement. The optional label can be used by EXIT and CONTINUE statements within nested loops to specify which loop those statements refer to.

38.6.3.2. EXIT
EXIT [ label ] [ WHEN boolean-expression ];
[/Quote]

LOOP
-- some computations
IF count > 0 THEN
EXIT; -- exit loop
END IF;
END LOOP;