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 vote144 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote145 views1 answer
Convert .mdf to .bak
SQL
0 vote155 views1 answer
Mysql custom sort order
SQL
0 vote160 views1 answer
Redshift running queries
SQL
0 vote151 views1 answer
Ubuntu stop mysql from starting on boot
SQL
3 votes131 views2 answers
To_char sql
SQL
0 vote153 views1 answer
Oracle sql number to varchar2
SQL
0 vote195 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
8 votes141 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote130 views1 answer
Change default schema sql server
SQL