Re: [Firebird-devel] CTE inside EXECUTE BLOCK or STORED PROCEDURE

[Vlad K. <hv...@us...>]

> Today i had to use CTE´s inside an EXECUTE BLOCK, and i found a limitation:
>
> Altought CTE is allowed inside blocks and procedures, it seems it's
> not possible to use it with FOR SELECT, to pick each row individually.
>
> Did i miss something or this is 'as-designed'?

    The WITH clause is a part of whole select. So, the syntax for PSQL is

FOR
  WITH ...
  SELECT ...
    INTO ...
DO ...

Regards,
Vlad