[sqlalchemy] Re: simulate sql view from table definition

2008-04-10 Thread Acm
Thank you. However, when the types of user (defined as Table()) and adults (the select object) are different types. I would like the adults variable to be of the same type as user. Is this possible? Thanks On Apr 9, 1:18 pm, Gerhard Häring [EMAIL PROTECTED] wrote: Acm wrote: I am working

[sqlalchemy] Re: simulate sql view from table definition

2008-04-09 Thread Gerhard Häring
Acm wrote: I am working with SQLAlchemy 0.4.5 I have this table definition: table1_def = Table('mytablename', metadata, schema='myschemaname', autoload=True) Now I would like a view on this table such that I only load the records where column1 = 0. I would like to define my view