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

0 vote199 views1 answer
How to make case insensitive in sql
SQL
0 vote193 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote210 views1 answer
Mysql, how to query the table comments?
SQL
6 votes235 views5 answers
Oracle list tablespaces
SQL
3 votes201 views1 answer
Only join in sql
SQL
1 vote222 views1 answer
Sql drop schema
SQL
0 vote260 views1 answer
000webhost database values insert
SQL
0 vote212 views1 answer
Sql server update top n records
SQL
0 vote208 views1 answer
Soql more than today
SQL
-1 vote226 views1 answer
Mysql delete duplicate rows except one
SQL