another option for blob columns and similar is the "deferred()" property, which will only load that column on the instance when first accessed. this is also in the docs (and probably is in the book too).
On Oct 7, 10:03 am, "Martijn Moeling" <[EMAIL PROTECTED]> wrote: > Thanx! > > In Mysql it seems to be func.octet_length(OBJ.columname) though > > All the documentation is very confusing, I started out with essential > SQLAlchemy which is completely outdated by now... > > The online docs are not very helpful if you don't know what yu're > lokking for. > > The column specification increases my performance a lot > > Martijn Moeling > > -----Oorspronkelijk bericht----- > Van: [email protected] [mailto:[EMAIL PROTECTED] > Namens Empty > Verzonden: Tuesday, October 07, 2008 3:18 PM > Aan: [email protected] > Onderwerp: [sqlalchemy] Re: limit the set of returned columns > > Hi, > > > > > Yesterday I was searching this group and the SA 5.0 doc to get > something > > working. Somewere I came across an option to specify the columnames to > > return > > You can specify the column names as part of the query, like > session.query(User.name, User.phone). > > > > > Filename, permissions and the "size of" Store > > > I think I need func from sqlalchemy.sql but whatever I try I cannot > find any > > sizeof or alike, I know MySQL has something like that. > > func.length() > > Michael --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
