Обсуждение: Working around insert into a_table from select things from a_function

Поиск
Список
Период
Сортировка

Working around insert into a_table from select things from a_function

От
Shaozhong SHI
Дата:
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

От
Karsten Hilbert
Дата:
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

От
Rob Sargent
Дата:
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