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 vote360 views1 answer
Mysql select random rows large table
SQL
9 votes371 views2 answers
Convert data type in sql
SQL
0 vote345 views1 answer
Set a default value for a column in sqlite
SQL
3 votes347 views2 answers
How to load files in mysql
SQL
0 vote433 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote360 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
8 votes343 views1 answer
Declare table variable sql server
SQL
5 votes356 views3 answers
Db begintransaction laravel
SQL
5 votes356 views2 answers
Get number of columns sql
SQL
1 vote341 views1 answer
Pl sql insert into table
SQL