Re: BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

 wrote:
 
>  x1 | x2 | x3 
> ----+----+----
>     |  1 |  1
 
To reduce the ambiguity about what value is coming from where, I
slightly modified the script before testing it against a recent HEAD
build:
 
create table t (c integer);

create function p(out x1 integer, out x2 integer, out x3 integer)
as $$
begin
    insert into t values (1),(2);
    get diagnostics x1 = row_count;
    insert into t values (3),(4),(5);
    get diagnostics x2 = row_count;
    insert into t values (6),(7),(8),(9),(10);
    get diagnostics x3 = row_count;
end;
$$ language plpgsql;

select * from p();
 
I got this:
 
 x1 | x2 | x3 
----+----+----
    |  3 |  5
(1 row)
 
-Kevin