> > R> BTW, may I fill next RFC: "Implement INSERT INTO ... VALUES ...
> > R> RETURNS ..." that would also return some inserted values (useful for
> > R> INSERT statements that contain gen_id() calls).

AFAIU, we will already have this this FB 2.0:

EXECUTE BLOCK (a INTEGER, b VARCHAR(10)) RETURNS (id INTEGER) AS
BEGIN
id = gen_id(my_generator, 1);
INSERT INTO my_table (col_id, col_a, col_b) VALUES (:id, :a, :b)
END

This is, in my opinion, far more powerful and orthogonal solution.

> > ...and DEFAULTs as well. I'm with you 100% on this one.
> > More useful than the SP stuff... ;->

... and it even includes defaults, as in
EXECUTE BLOCK (a INTEGER = 10, b VARCHAR(10) = 'abc')
...