Working around insert into a_table from select things from a_function

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Working around insert into a_table from select things from a_function
Date: 2023-07-04 16:58:58
Message-ID: CA+i5JwbRD7fKQH8BBLbruqUc-RUg=mGFd3ZMdS+zKRsLOvZZcg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karsten Hilbert 2023-07-04 17:09:43 Aw: Working around insert into a_table from select things from a_function
Previous Message Tom Lane 2023-07-04 14:47:47 Re: How come column is locked?