for the SQL expression language we try not to guess things like that. the difference between a select() and an alias() is pretty big.
On Jan 29, 2009, at 12:36 PM, Bob Farrell wrote: > > Hi, > > query.count().scalar() > > This code works fine with sqlite and Oracle, but with PG it goes > nuts and > complains that an explicit "AS" must be used in a subselect, i.e. > it's doing > this: > > select count(*) as blah from (select ...) > > But PG wants this: > > select count(*) as blah from (select ...) as boom > > Doing this fixes the problem: > > query.alias().count().scalar() > > But to me this seems like a deficiency in the dialect - shouldn't > the "AS" be > added automagically ? > >>>> sqlalchemy.__version__ > '0.5.0rc4' > > It's no biggie but seems worth pointing out in case you weren't > aware of it. > > Thanks. :-) > -- > -------------------------- > Bob Farrell > pH, an Experian Company > www.phgroup.com > Office Line: 020 7598 0310 > Fax: 020 7598 0311 > -------------------------- > > > --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---