31.05.2021 18:38, Mark Rotteveel wrote:
What is the real problem you're trying to solve? The current syntax is
20+ years old, and I think this is one of the first times (if not the
first time) I hear complaints about its verbosity, or a need to
selectively obtain output columns.
Blame me ;-)
This thread has originated from the discussion in PR #281 where I
suggested to consider less verbose typing for packaged routines in PSQL,
compare:
execute procedure rdb$blob_util.append(...); -- packaged procedure
vs
rdb$blob_util.seek(...); -- packaged function
Our functions historically required to return the result, i.e. looked
like this:
some_var = rdb$blob_util.seek(...);
but later (FB v1.5, IIRC) the syntax was relaxed to allow a call without
the explicitly returned value. And this is really handy when used in PSQL.
In turn, procedures have a more verbose syntax (EXECUTE PROCEDURE) and
still don't allow to ignore the results, which looks somewhat inconsistent.
This is not something extremely important, but our EXECUTE PROCEDURE is
really showing its age with some syntax weirdness and maybe it makes
sense to polish it up a little.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
