On Thu, Dec 26, 2019 at 9:33 AM stan <stanb@xxxxxxxxx> wrote:
WITH inserted AS (
INSERT into project_cost_category
(category)
VALUES
('MISC')
RETURNING
*
)
SELECT project_cost_category_key
INTO NEW.project_cost_category_key =
( SELECT
project_cost_category_key
FROM
inserted )
You have two SELECTs. The "inner" one has a FROM clause attached to it providing columns from the "inserted" CTE. The "outer" one doesn't have a FROM clause and so doesn't have access to columns. The "outer" SELECT project_cost_category_key is thus invalid.
David J.
