Closed
Description
Migrated issue, originally created by Anonymous
(original reporter: ants) PostgreSQL supports returning the changed rows from an update statement. The syntax is ''regular_update_clause + ' RETURNING ' + column_list'', where column_list has the exact same syntax as the one in a select clause.
To support this it would be necessary to:
- Support adding a column list to an update clause by either adding it to a regular Update class or subclassing it for Postgres.
- Make the compiler support it.
- Make the ExecutionContext properly recognize it as a select. Changing the regexp to r'\s*(?:SELECT|FETCH|UPDATE.*RETURNING)' would work most of the time, but it should check that the RETURNING keyword isn't quoted.
Activity
sqlalchemy-bot commentedon Oct 2, 2007
Anonymous wrote:
(original author: ants) Added together with insert support in e82ca71. Uses the postgres_returning kwarg.
sqlalchemy-bot commentedon Oct 2, 2007
Changes by Anonymous: