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

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To:
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Aw: Working around insert into a_table from select things from a_function
Date: 2023-07-04 17:09:43
Message-ID: trinity-c946aab7-e22e-4bc2-b0cf-0cc0443e0e05-1688490583722@3c-app-gmx-bs48
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Von: "Shaozhong SHI" <shishaozhong(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2023-07-04 18:39:09 Re: How come column is locked?
Previous Message Shaozhong SHI 2023-07-04 16:58:58 Working around insert into a_table from select things from a_function