我该如何多次使用with语句?
如果像下面的代码一样,我不能将其用于除紧随其后的语句以外的任何语句。
WITH insertuser AS (
INSERT INTO
zorro.user (username, firstname, lastname,
accountstatus, roles, creationdatetime)
VALUES('test', 'test', 'test',
'test', 'test', current_timestamp)
RETURNING id
)
INSERT INTO
zorro.email (address, confirmed, count, user_id)
SELECT 'test', false, 1, id
FROM insertuser;
INSERT INTO
zorro.password (hash, count, user_id)
SELECT 'test', 1, id
FROM insertuser;
INSERT INTO
zorro.phone_number (number, confirmed, count, user_id)
SELECT 'test', false, 1, id
FROM insertuser;
INSERT INTO
zorro.Question (text, answer, count, user_id)
SELECT 'test', 'test', 1, id
FROM insertuser;
我在代码的第19行附近遇到了SQL错误,第二个"FROM insertuser"出现了问题。