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 vote332 views1 answer
Postgresql round double precision
SQL
0 vote307 views1 answer
Oracle select invalid views
SQL
2 votes369 views1 answer
How to check if a row is null in sql
SQL
13 votes334 views2 answers
Get tables in database sql
SQL
14 votes329 views3 answers
Sql trim from string
SQL
0 vote324 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote371 views1 answer
Oracle chain step succeeded
SQL
1 vote322 views1 answer
Simple project for database
SQL
19 votes347 views3 answers
How to change column type psql
SQL
0 vote350 views1 answer
How to move a columns location in mysql
SQL