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

8 votes92 views1 answer
Sql remove characters from string right
SQL
1 vote103 views1 answer
SQLSTATE[HY000] [2002]
SQL
15 votes162 views3 answers
Postgresql change column type
SQL
0 vote132 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote106 views1 answer
Sqlalchemy order by descending
SQL
0 vote99 views2 answers
Mysql select date from datetime
SQL
1 vote104 views1 answer
Pl sql create table from another table
SQL
58 votes262 views6 answers
Create new user in postgres
SQL
0 vote117 views1 answer
Sql server roles and users
SQL
0 vote98 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL