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 vote129 views1 answer
Sql express database size limit
SQL
20 votes167 views4 answers
How to find average in sql
SQL
0 vote146 views1 answer
Check command
SQL
1 vote127 views1 answer
Mysql random limit 1
SQL
1 vote127 views1 answer
Oracle stop job
SQL
0 vote125 views1 answer
Mysqldump ignore table
SQL
4 votes122 views3 answers
Create database in mySQL
SQL
0 vote133 views1 answer
Comma seperated join mssql
SQL
13 votes126 views4 answers
Mysql get last row
SQL
0 vote127 views1 answer
Database xml sql
SQL