Re: [Sqlalchemy-users] Syntax for performing a SELECT inside an INSERT?

2006-07-14 Thread Ricky Iacovou
On Thursday 13 July 2006 19:44, Michael Bayer wrote: > we havent gotten around to supporting INSERT from a SELECT, as a > python-constructed SQL clause, as of yet. is there any reason you > cant just use a plain text() query for this ? No, not at all. I was just hoping that there was some way of

[Sqlalchemy-users] Syntax for performing a SELECT inside an INSERT?

2006-07-13 Thread Ricky Iacovou
Hi there. I'm moving some SQLObject code to SQLAlchemy, and I can't work out how to do something. I'm sure it's trivially simple, I just can't see anything like it in the documentation, and my trial-and-error approach hasn't worked so far. A bare-bones is described below: Assume two na