Re: [sqlalchemy] Re: Literal table expression (VALUES clause) in select

2010-02-28 Thread Michael Bayer
On Feb 26, 2010, at 6:28 AM, Gunnlaugur Briem wrote: > This produces the equivalent SELECT ... UNION ALL ... UNION ALL ... > using select, literal_column and union_all (and leaving aside the > details of representing the literal values inside the VALUES clause) > --- works just fine and PostgreSQ

[sqlalchemy] Re: Literal table expression (VALUES clause) in select

2010-02-26 Thread Gunnlaugur Briem
This produces the equivalent SELECT ... UNION ALL ... UNION ALL ... using select, literal_column and union_all (and leaving aside the details of representing the literal values inside the VALUES clause) --- works just fine and PostgreSQL produces the same query plan for it: num_columns = len(weigh