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 vote137 views1 answer
Add column not null with default value postgres
SQL
0 vote141 views1 answer
Search db for table name
SQL
1 vote127 views1 answer
Can not connect to mysql server
SQL
0 vote145 views1 answer
Sql find gaps in date ranges
SQL
0 vote142 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote141 views1 answer
Oracle right characters
SQL
6 votes150 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote160 views1 answer
Reset postgresql password windows
SQL
4 votes135 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote128 views1 answer
How to stop all connections to a psql 12 database?
SQL