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

9 votes212 views2 answers
Get first 3 letters in sql
SQL
0 vote357 views1 answer
The differnece between to values in sql
SQL
0 vote217 views1 answer
Test database for sql
SQL
0 vote226 views1 answer
Create table sql generator
SQL
19 votes237 views6 answers
Create table sqlite
SQL
0 vote174 views1 answer
Oracle function select into
SQL
0 vote227 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
3 votes221 views3 answers
Restart mysql mac
SQL
0 vote226 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote223 views1 answer
Postgres reorder columns
SQL