On 2019-08-12 11:53, 'Check_Mail' check_mail@...
[firebird-support] wrote:

> Hello,
>
> I have created a CTE in a stored prodedure which gives me all terms of
> the next days, for example:
>
> 01.10.2019 Meeting with..
>
> 01.10.2019 Exkursion
>
> 02.10.2019 Termin
>
> 04.10.2019 Termin XX
>
> Now I would set between every day a blank record, a kind of space.
>

[..]

>
> Can I select a blank record between the days?

That is not something you should fix in your query, you should do that
in your presentation layer (eg add a blank line when the date changes)

Mark