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 vote247 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote237 views1 answer
Partitioning in oracle-base
SQL
0 vote242 views2 answers
Athena drop partition
SQL
2 votes250 views2 answers
Sql percentage
SQL
0 vote238 views1 answer
Psql datestyle
SQL
0 vote227 views1 answer
Getting next sequence value jpa postgress
SQL
9 votes228 views4 answers
How to remove duplicate in sql
SQL
0 vote231 views1 answer
Drop a field in psql django
SQL
-1 vote253 views4 answers
Postgres between dates
SQL
2 votes245 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL