|
|
| Definitions More Info. | | Definition ID | 693 | | Title | POSTGRESQL | | Category | SCRIPT | | Definition | WHILE loop - dongusu ornek2 | | Definition Description | /*
DO $$
DECLARE i integer;
BEGIN
i:=0;
WHILE(1=1)
LOOP
RAISE NOTICE 'LOOP : %',i;
i=i+1;
END LOOP;
END $$;
*/
DO $$
DECLARE i integer;
BEGIN
i:=0;
WHILE(i<=10)
LOOP
RAISE NOTICE 'LOOP : %',i;
--PERFORM pg_sleep(1);
INSERT INTO "film_yedek"( "title", "description", "release_year", "language_id", "rental_duration", "rental_rate", "length", "replacement_cost", "rating", "last_update", "special_features", "fulltext")
SELECT "title", "description", "release_year", "language_id", "rental_duration", "rental_rate", "length", "replacement_cost", "rating", "last_update", "special_features", "fulltext"
FROM "film";
--PERFORM * FROM film_yedek;
i=i+1;
END LOOP;
END $$; | | RecordBy | cunay | | Record Date | 24-12-2015 17:39:57 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|