i am storing only accounting amounts so i do care... long time ago there was no decimals easily available, so we used a fixed-point arithmetic (over integers) instead of decimals. either way, u cant store 1/3, and i dont think any db supports fractions.
On Friday 24 August 2007 12:17:39 Florent Aide wrote: > How would you do something like this then: > > session.query.(LedgerLine).query(LedgerLine.base_amount.between(dec >imal1, decimal2)) > > the between() won't work since sqlite won't be able to compare your > pickled amounts. > > Pickling cannot be an option in all cases particularly when you are > storing amounts for accounting books... > > Florent. > > On 8/24/07, svilen <[EMAIL PROTECTED]> wrote: > > decimals.. u can use pickling? slower, yes. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---