With Returning
From PostgreSQL wiki
Jump to navigationJump to searchWITH [RECURSIVE] RETURNING
- TODO for David Fetter
- TODO for Dan Colish
- Get some more bounty queries
- merge refactoring of executor into writable_cte branch
- TODO for Marko Tiikkaja
- Make ExecutePlan() a bit prettier ( http://archives.postgresql.org/pgsql-hackers/2009-11/msg01860.php )
- Change the grammar to allow WITH before INSERT, UPDATE and DELETE [D]
- Fix DO ALSO SELECT .. rule logic [D]
- Implement execute-once property for CTEs with INSERT/UPDATE/DELETE [D]
- Allow non-referenced CTEs have INSERT/UPDATE/DELETE without RETURNING [D]
- Fix trigger behaviour inside queries which have SELECT as top-level query [D]
- Rethink how result relations should be handled [D]