Vincenzo Romano <vincenzo.romano@xxxxxxxxx> writes: > Second, I'm not using nested statements, but rather a plain > INSERT ... RETURNING COUNT(*) INTO var (it's inside a PL/PgSQL > function body). It should not need any GROUP BY as the query is > plain. > Maybe the solution is somewhere in between what you say and what I'd > expect. Of course at the moment I have added an extra SELECT COUNT(*) > in order to get that number. Umm ... doesn't GET DIAGNOSTICS integer_var = ROW_COUNT; do what you want? regards, tom lane
