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 votes124 views1 answer
Wait delay in sql server
SQL
1 vote158 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote140 views1 answer
Codeigniter dbforge add index
SQL
0 vote164 views10 answers
John the ripper mysql
SQL
1 vote274 views1 answer
Sql check roles
SQL
17 votes135 views6 answers
Current date in sql
SQL
0 vote132 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote139 views2 answers
Disallowed function mysql to_date()
SQL
2 votes151 views1 answer
Capitalize 1st letter in sql server
SQL
15 votes144 views2 answers
Select where duplicate mysql
SQL