For loop postgresql

FOR r IN SELECT * FROM foo
    WHERE fooid > 0
    LOOP
        -- can do some processing here
        RETURN NEXT r; -- return current row of SELECT
    END LOOP;

Similar codes

3 votes373 views1 answer
Create a table with an id in mysql
SQL
0 vote366 views1 answer
Get a list of tables and the primary key
SQL
1 vote335 views1 answer
Oracle stop job
SQL
-1 vote352 views1 answer
Mac mysql workbench console
SQL
2 votes331 views2 answers
Oracle multiple insert
SQL
1 vote325 views1 answer
Sql comment header
SQL
0 vote366 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote366 views2 answers
Sql queries practice
SQL
-1 vote360 views1 answer
Sql show custom constraints
SQL
0 vote371 views1 answer
Faire une recherche par liste de mot clé sql
SQL