Re: table returning function for each row in other resultset

[David G. Johnston]

On Wed, Feb 3, 2021 at 8:01 AM Niels Jespersen <n...@dst.dk> wrote:

> Hello all
>
> I have som data in a resultset. E.g:
>
> id date_begin date_end      amount
> 1  2021-01-04 2021-02-06  100
> 2  2021-03-17 2021-05-11  234
>
> I have a table returning function that can take one row and split it into
> constituent monthpieces and distribute amount proportionally.
>
> select * from func(1, 2021-01-04, 2021-02-06, 100);
> [...]
> How can I accomplish this, please.
>

Lateral Join.

(not tested)
SELECT *
FROM resultset, func(id, date_begin, date_end, amount);

David J.