Re: Closing Gaps in Celko trees

"Ben-Nes Michael" <miki@canaan.co.il> writes:
> WHILE EXISTS ( SELECT * FROM gaps )
> ...
> END WHILE;

The docs show a different syntax for plpgsql's WHILE loops:

WHILE expression LOOP
    statements
END LOOP;

            regards, tom lane