On 15-08-2022 12:40, Simonov Denis via Firebird-devel wrote:
I'm talking about the fact that EXECUTE STATEMENT supports named
parameters, including those for EXECUTE BLOCK. There's even a special
query preparser for that. Those who implement client libraries will have
to do much the same. And if for EXECUTE BLOCK the prepaser is quite
simple (named parameters need to be searched only between EXECUTE BLOCK
and the first AS), then for such a syntax it will not be very trivial.
In your version, I don't see how even EXECUTE STATEMENT can work with
named parameters.
The named parameters in the example are basically equivalent to stored
procedure / execute block parameters (a.k.a. PSQL variables), and PSQL
supports named parameters in SQL.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
