... <看更多>

You have considerable structural errors in your code block: DO $$ DECLARE i INT := 0; BEGIN WHILE i <= numberUsers --<<< numberUsers is ... ... <看更多>

PostgreSQL cursor example. GitHub Gist: instantly share ... db = PG.connect dbname: 'postgres' ... LOOP. FETCH FROM curs INTO row;. EXIT WHEN NOT FOUND;. ... <看更多>

The DO command has no facility to actually return data (except with RAISE , or you could write to a (temp) table .. ). ... <看更多>