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 vote201 views1 answer
Mssql find deadlocks
SQL
0 vote167 views1 answer
Sqlite select split string
SQL
0 vote164 views1 answer
Monthly Birthday SQL Query
SQL
0 vote169 views1 answer
QUERY JPQL
SQL
0 vote169 views1 answer
Firebird where
SQL
0 vote156 views1 answer
Oracle create package body
SQL
0 vote178 views1 answer
Mysqldump don't drop table
SQL
5 votes164 views1 answer
Alter table add comment oracle
SQL
2 votes172 views2 answers
Mysql limit
SQL
49 votes251 views6 answers
Get duplicate records in sql
SQL