Vlad Khorsun wrote 15.08.2022 19:42:
Also, I don't like 'sql' word, especially after 'execute statement' and
'execute
block'. Too much, as for me :) Syntax with 'with' instead of 'execute sql' looks
much better to me, but it is already used in CTE's, thus it seems as not the
best
choice :(
I see no difference between proposed syntax and WITH except of definition of
functions instead of derived tables in CTE part.
What is wrong with expanding it into something like this:
WITH
function subfunc (i1 integer) returns integer
as
begin
return i1;
end,
procedure subproc (i1 integer) returns (o1 integer)
as
begin
o1 = i1;
suspend;
end,
derives_table
as
(select current_time from rdb$database)
select subfunc(?) + o1
from subproc(?) join dt on 1=1
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
