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 vote140 views1 answer
Ms sql database data size
SQL
1 vote146 views1 answer
Sql where last 12 months
SQL
0 vote131 views1 answer
Postgres create database if not exists
SQL
1 vote143 views1 answer
Deleting database in sql
SQL
5 votes148 views3 answers
Mysql check if null or empty string
SQL
0 vote158 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
2 votes153 views3 answers
How to check current user in mySQL
SQL
0 vote162 views1 answer
Postgresql inheritance
SQL
1 vote161 views1 answer
Postgresql round double precision
SQL
3 votes174 views1 answer
What is having
SQL