Thread: Working around insert into a_table from select things from a_function

Working around insert into a_table from select things from a_function

From
Shaozhong SHI
Date:
I can manually select columns from a_function.

But, when in a loop in a do statement, it does not work.

These columns are of array type.

Can anyone shed light on this?

Regards,

David

Aw: Working around insert into a_table from select things from a_function

From
Karsten Hilbert
Date:
Von: "Shaozhong SHI" <shishaozhong@gmail.com>
>
>I can manually select columns from a_function.
> 
>But, when in a loop in a do statement, it does not work.
> 
>These columns are of array type.
> 
>Can anyone shed light on this?

Sure. You yourself. By providing relevant detail.

It seems rather unthoughtful to have people second-guess your environment.

Best,
Karsten



Re: Working around insert into a_table from select things from a_function

From
Rob Sargent
Date:
On 7/4/23 10:58, Shaozhong SHI wrote:
I can manually select columns from a_function.

But, when in a loop in a do statement, it does not work.

These columns are of array type.

Can anyone shed light on this?

Regards,

David
show your select statement and full do loop