and what this is expected to do? x = task and (max(task.sequence)+100) or 100 ?
Jonathan LaCour wrote: > I have been banging my head against the wall for a little bit > attempting to translate this SQL: > > SELECT max(value) FROM ( > SELECT max(sequence)+100 as value FROM task > UNION > SELECT 100.0 as value > ) > > into an SQLAlchemy expression that I can embed into an INSERT. > Should I just go ahead an use text() rather than bother with > attempting to construct this using an SQLAlchemy expression? > > (Yes, I know that this is gross...) > > -- > Jonathan LaCour > http://cleverdevil.org > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---