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

2 votes302 views2 answers
Create empty table from existing table
SQL
0 vote275 views1 answer
Renombrar tabla mysql
SQL
0 vote312 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote283 views1 answer
Mysql grant grant option
SQL
0 vote270 views1 answer
Mysql date only no time
SQL
0 vote277 views1 answer
How to find sql server name
SQL
0 vote299 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote270 views1 answer
Sqlalchemy query return only n results
SQL
0 vote306 views2 answers
Temp tables in sql server
SQL
20 votes291 views5 answers
Sql show tables
SQL