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

15 votes322 views5 answers
Show tables in oracle
SQL
0 vote271 views1 answer
Mysql timeout 30 seconds
SQL
0 vote265 views0 answer
SQL
1 vote290 views1 answer
T-SQL Alter the column data type
SQL
0 vote270 views1 answer
Get only first row mysql
SQL
0 vote311 views1 answer
Sqlite to csv statement
SQL
2 votes347 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote315 views1 answer
Name '_mysql' is not defined
SQL
0 vote251 views1 answer
Mysql select top 2
SQL
4 votes288 views3 answers
Count with where
SQL