Hi!

You can use name of fields in SQL and don't need to remember order of the fields. For example:

create table t (x integer, y integer);

insert into t (y, x) values (2, 1);
update t set y = 1, x = 0;
select y from t;


I'm proposing the same thing for input arguments of stored procedures:

create procedure sp (x integer, y integer)
as
begin
end;

execute procedure sp with x = 1, y = 2;
execute procedure sp with y = 2;
execute procedure sp with x = 1;
execute procedure sp with y = 2, x = 1;

select * from sp with y = 2;


Adriano