[sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Jon Nelson
How do I translate the following: select A.column, V.queried from A, (VALUES ( ('foo'), ('bar') )) as V (queried) where A.column2 = V.queried; into sqlalchemy-speak. I'm not using the ORM. http://www.postgresql.org/docs/8.4/static/sql-values.html -- Jon -- You received this message because

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Michael Bayer
it is here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628d7ebee5/4421b272d4c7f91f let me add that to the wiki On May 17, 2010, at 8:46 AM, Jon Nelson wrote: How do I translate the following: select A.column, V.queried from A, (VALUES ( ('foo'), ('bar') )) as V

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Jon Nelson
On Mon, May 17, 2010 at 8:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: it is here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628d7ebee5/4421b272d4c7f91f let me add that to the wiki Cool! However, http://www.postgresql.org/docs/8.4/static/sql-values.html

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Jon Nelson
On Mon, May 17, 2010 at 8:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: it is here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628d7ebee5/4421b272d4c7f91f let me add that to the wiki The part about the thread that worries me a bit is this: (%s) % ,

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Michael Bayer
On May 17, 2010, at 10:14 AM, Jon Nelson wrote: On Mon, May 17, 2010 at 8:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: it is here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628d7ebee5/4421b272d4c7f91f let me add that to the wiki The part about

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Jon Nelson
On Mon, May 17, 2010 at 9:32 AM, Michael Bayer mike...@zzzcomputing.com wrote: On May 17, 2010, at 10:14 AM, Jon Nelson wrote: On Mon, May 17, 2010 at 8:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: it is here:

Re: [sqlalchemy] constant tables / VALUES expression

2010-05-17 Thread Michael Bayer
On May 17, 2010, at 10:55 AM, Jon Nelson wrote: On Mon, May 17, 2010 at 9:32 AM, Michael Bayer mike...@zzzcomputing.com wrote: On May 17, 2010, at 10:14 AM, Jon Nelson wrote: On Mon, May 17, 2010 at 8:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: it is here: