Vincenzo Romano <vincenzo.romano@gmail.com> 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