As the error states it needs to be a record or a list. Introduction to PostgreSQL For Loop In the PostgreSQL database, we can use many conditional and looping statements. Not only is everything run in a single query, but PostgreSQL can also use a more effective join strategy if that is better. It is also a kind of home-grown nested loop join. The error is occurring as you did not DECLARE timesheetdate correctly. Still, the executor has to run many times, and PL/pgSQL is known not to be particularly fast. Looping through a Cursor's Result Rather than executing a whole query at once, it is possible to set up a cursor that encapsulates the query, and then read the query result a few rows at a time. The cursor FOR loop is a loop construct that eliminates the need to. I think that should work in 8.1 but I don't have access to 8.1 to check. 1 So how is the variable timesheetdate defined ahorsewithnoname at 17:33 3 You need to show the complete function. The programming logic required to process the result set of a cursor usually includes a statement to open the cursor, a loop construct to retrieve each row of the result set, a test for the end of the result set, and a statement to close the cursor. If you're stuck in the 8.1 stone age and can't do anything about it, then perhaps something like this would work: create or replace function ff(int, text) returns integer as $$ You could also use regexp_split_to_table: create or replace function ff(int, text) returns integer as $$įrom regexp_split_to_table($2, ',') as dt(s) This will do though (but someone can probably make it cleaner) INSERT INTO articles WITH RECURSIVE i AS ( SELECT 1 x UNION ALL SELECT x + 1 FROM i WHERE x < 10000000 ) SELECT x FROM i Share.

I've also corrected some typos ( RETRUNS, RETRUN, and pgsql) along the way. Afaik, you cant write a loop directly as SQL, youd have to create a stored procedure to do it.

select construct: create or replace function ff(int, text) returns integer as $$įrom unnest(string_to_array($2, ',')) as dt(s) Since PostgreSQL 9.1 you can use FOREACH LOOP to iterate over an array. You don't need a loop for that, you could use unnest to convert the array from string_to_array into a set of rows and then use a simple insert.

Postgresql for loop