Re: table returning function for each row in other resultset

On Wed, Feb 3, 2021 at 8:01 AM Niels Jespersen <NJN(at)dst(dot)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.