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 vote210 views1 answer
Postgres can integer fields be negative
SQL
5 votes202 views1 answer
Invalid column name sql
SQL
0 vote200 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote209 views1 answer
Components/Fields of Internal Table
SQL
1 vote235 views1 answer
Postgresql blocked on mac
SQL
0 vote205 views1 answer
Java check if something is in mysql table
SQL
1 vote211 views3 answers
Reset sql primary key
SQL
0 vote196 views1 answer
How to print out column name differently in mysql
SQL
0 vote284 views1 answer
Offset in postgresql example
SQL
1 vote215 views1 answer
How to see all table partition in oracle
SQL