Inserting multiple rows wtih a SELECt in the values clause

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Inserting multiple rows wtih a SELECt in the values clause
Date: 2019-10-15 13:52:24
Message-ID: 20191015135224.GA3910@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK, now that figured out how to return the constant, this is the final
query I need to run.

INSERT into rate
(
employee_key ,
project_key ,
work_type_key ,
rate
)
VALUES
(
(
SELECT
employee.employee_key ,
project.project_key ,
work_type.work_type_key ,
1 as rate
FROM employee
CROSS JOIN project
CROSS JOIN work_type
)
);

But this fails.

I suspect this may be because the SELECT in the values clause returns
multiple rows?

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2019-10-15 14:25:00 Re: SELECT returnig a constant
Previous Message Tomas Vondra 2019-10-15 13:47:21 Re: timescaleDB & WAL replication