On Mar 15, 2007, at 5:09 AM, Glauco wrote:

> because i expect that engine do a SELECT COUNT FROM BLABLA and no a  
> SELECT COUNT FROM ( SELECT BLABLA)
> i think this is expensive for my  DataBase.
>

its not.  optimizers can usually figure things like that out.

> I've done a lot of try.... this don't work....
>
> print select([tbl['azienda'].c.id],  tbl['azienda']).execute()
>

what happened to table.count() ?  if you want to count manually:

select([func.count(table.c.whatevercolumn)]).execute()




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
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