Postgres Pro
Downloads
Home   >   mailing lists

Re: Closing Gaps in Celko trees - Mailing list pgsql-general

From Tom Lane
Subject Re: Closing Gaps in Celko trees
Date
Msg-id 9503.1027495763@sss.pgh.pa.us
Whole thread Raw
In response to Closing Gaps in Celko trees  ("Ben-Nes Michael" <miki@canaan.co.il>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Pierre-Yves LANDURE
Date:
Subject: need help : how to replace / extend existing SQL operators ?
Next
From: "Tuomas Vanhanen"
Date:
Subject: Security, IP and username restrictions