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

2 votes100 views1 answer
Sql view column data type
SQL
1 vote164 views1 answer
Sql select contem uma palavra
SQL
6 votes135 views1 answer
Rank function in oracle with example
SQL
0 vote214 views1 answer
Import sql dump into postgresql database
SQL
2 votes168 views2 answers
Convert_tz mysql
SQL
5 votes154 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
1 vote137 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote145 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote393 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
2 votes159 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL