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 vote260 views1 answer
Oracle create_program
SQL
0 vote264 views1 answer
Select last N rows mysql
SQL
0 vote275 views1 answer
Remove binlog mysql
SQL
2 votes255 views1 answer
Sqlite indexes
SQL
0 vote273 views1 answer
Creating a simple notify in postgresql
SQL
6 votes323 views2 answers
Oracle compile trigger
SQL
0 vote280 views1 answer
In query in sql
SQL
1 vote278 views1 answer
Sql order by where condition
SQL
0 vote268 views1 answer
Import excel to sql
SQL
62 votes337 views8 answers
Mysql add column
SQL