Re: Returning generated id after a transaction.

Hi,

there is option no. 4 (kind of extended WITH)

WITH 

inserted_row AS (

INSERT INTO "tblParent" ("RowValue")

VALUES ('2012-01-01'::date)

RETURNING *

), 

updated_row AS (UPDATE "tblChild"

SET "ParentRowId" = (SELECT "RowId" FROM inserted_row)

WHERE "RowId" = 123 --whatever You need

)

SELECT "RowId" FROM inserted_row;

I missed it in previous post.

This could be part of function (SELECT statement should be modified) or ad-hoc query.

Regards,
Bartek