Impossible to Insert with a select *

Hello,

I'm trying to add multiple rows with arrays as parameters.
I have a query like this:

INSERT INTO pages_users (user_id, page_id)
SELECT *
FROM UNNEST(sqlc.arg(user_ids)::bigint[], sqlc.arg(page_ids)::VARCHAR(55)[]);

This is my error message:

postgres/queries/pages.sql:18:1: empty edit contents

But the query seems to be valid, I can execute it on postgres.

Thank you for your help.

Navigation Menu