select([literal("1").label(field)], from_obj=[foo])

or to not use the bind param

select([literal_column("1").label(field)], from_obj=[foo])


On Jul 3, 9:32 am, Expo <[EMAIL PROTECTED]> wrote:
> If I would make a select with a field set to a constant like this:
>
> SELECT 1 AS field FROM foo
>
> how is the select()'s field definition ? I'v tried with:
>
> select([1], from_obj=[foo])
>
> but field has no name.


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to