Inserting multiple rows wtih a SELECt in the values clause - Mailing list 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