Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-09 Thread jo
Michael Bayer wrote: jose soares wrote: Michael Bayer wrote: jo wrote: I was using heavily the column_prefix and my code is full of it, as in: mapper(Anagrafica, tbl['anagrafica'], column_prefix = 'anagrafica_', extension=History(),

Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-08 Thread jose soares
Michael Bayer wrote: jo wrote: I was using heavily the column_prefix and my code is full of it, as in: mapper(Anagrafica, tbl['anagrafica'], column_prefix = 'anagrafica_', extension=History(), properties = { 'comune' : relation( Comune,

Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-08 Thread Michael Bayer
jose soares wrote: Michael Bayer wrote: jo wrote: I was using heavily the column_prefix and my code is full of it, as in: mapper(Anagrafica, tbl['anagrafica'], column_prefix = 'anagrafica_', extension=History(), properties = { 'comune'

[sqlalchemy] SQLAlchemy.func.max()

2010-04-07 Thread jo
Here another difference between Oracle and PostgreSQL The SQLAlchemy.func.max() on a column date, returns a datetime.date in pg but a datetime.datetime in oracle... Why this difference? take a look: Bolletta = Table('bolletta', database.metadata, Column('id', Integer, nullable=False,

Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-07 Thread Michael Bayer
jo wrote: Here another difference between Oracle and PostgreSQL The SQLAlchemy.func.max() on a column date, returns a datetime.date in pg but a datetime.datetime in oracle... Why this difference? Oracle doesn't have a date type.this is another thing the types system smoothes out (can't

Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-07 Thread jo
Michael Bayer wrote: jo wrote: Here another difference between Oracle and PostgreSQL The SQLAlchemy.func.max() on a column date, returns a datetime.date in pg but a datetime.datetime in oracle... Why this difference? Oracle doesn't have a "date" type.this is another

Re: [sqlalchemy] SQLAlchemy.func.max()

2010-04-07 Thread Michael Bayer
jo wrote: I was using heavily the column_prefix and my code is full of it, as in: mapper(Anagrafica, tbl['anagrafica'], column_prefix = 'anagrafica_', extension=History(), properties = { 'comune' : relation( Comune, primaryjoin =