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 vote258 views1 answer
Output to file mysql
SQL
6 votes296 views2 answers
Mysql 1 day ago
SQL
1 vote252 views1 answer
Oracle lowercase
SQL
0 vote296 views1 answer
Oracle decode
SQL
0 vote263 views1 answer
Not between mysql
SQL
0 vote285 views1 answer
Mysql equivalent decode oracle
SQL
2 votes278 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote295 views1 answer
How do you insert boolean to postgresql
SQL
11 votes265 views4 answers
Query DISTINCT
SQL
51 votes461 views6 answers
Opera gx
SQL