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

1 vote220 views3 answers
Default password of mysql
SQL
6 votes193 views2 answers
Drop foreign key
SQL
0 vote178 views2 answers
Postgres default user
SQL
0 vote190 views2 answers
2nd max salary query in sql
SQL
1 vote193 views1 answer
Get create table query existing table mysql
SQL
0 vote197 views1 answer
Proc sql not in working
SQL
0 vote223 views1 answer
Mysql limit order by
SQL
1 vote217 views1 answer
Oracle schema size
SQL
0 vote164 views0 answer
SQL
2 votes142 views1 answer
Sql float to int
SQL