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 vote313 views1 answer
Create table like sql
SQL
37 votes280 views3 answers
Postgresql insert column
SQL
13 votes272 views4 answers
Mysql get last row
SQL
0 vote274 views1 answer
Mysql docker image for macbook m1
SQL
0 vote289 views1 answer
Case when with count and combining similar values in sql
SQL
12 votes315 views6 answers
How to install sqlite3 in python
SQL
0 vote304 views1 answer
Search from comma separated values in sql server
SQL
5 votes310 views2 answers
Postgresql add not null constraint
SQL
15 votes302 views4 answers
Mysql where value is null
SQL
0 vote307 views1 answer
Sql remove non numeric characters
SQL