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
Get create sql of hibernqte entity
SQL
0 vote168 views1 answer
Sql select without column name
SQL
0 vote120 views1 answer
Max length found in mysql
SQL
0 vote146 views2 answers
Insert data mysql with cmd
SQL
1 vote116 views1 answer
Customer using hdfc bank sql query
SQL
0 vote143 views1 answer
Set Mamp mysql globally
SQL
-2 votes115 views1 answer
How to open database
SQL
0 vote127 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote142 views1 answer
Varchar plsql
SQL
15 votes129 views5 answers
Show tables in oracle
SQL