Re: [Firebird-devel] New statement: EXECUTE SQL

[Mark R. <ma...@la...>]

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