Re: [Sqlalchemy-tickets] [sqlalchemy] #2551: apparently INSERTs (and UPDATE, DELETE) can have CTEs in pg 9.1. , plus UPDATE, SELECT, DELETE in CTEs. (was: apparently INSERTs (and UPDATE, DELETE) can have CTEs in pg 9.1. plus SELECT from INSERT, plus UPDATE in CTE.)

[sqlalchemy <mi...@zz...>]

#2551: apparently INSERTs (and UPDATE, DELETE) can have CTEs in pg 9.1.  , plus
UPDATE, SELECT, DELETE in CTEs.
------------------------------+---------------------------------------
      Reporter:  zzzeek       |      Owner:  zzzeek
          Type:  enhancement  |     Status:  new
      Priority:  medium       |  Milestone:  0.9.xx
     Component:  postgres     |   Severity:  very major - up to 2 days
    Resolution:               |   Keywords:
Progress State:  in queue     |
------------------------------+---------------------------------------

Comment (by zzzeek):

 INSERT from SELECT (I'm assuming that's what "SELECT from INSERT" was
 trying to say) is #722.

 A SELECT can have INSERT/UPDATE/DELETE inside the WITH clause, examples of
 this are in section 7.8.2 of http://www.postgresql.org/docs/9.1/static
 /queries-with.html

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2551#comment:6>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python