Django Admin adds trailing 0's

2010-09-04 Thread tresero
I have some fields that represent recommendations (forex). I modeled them as numeric(8,4) (postgresql). The problem is that the django admin automatically adds trailing 0's. I don't want that because in order to calculate profit/loss, I need to subtract the numbers (as integers, I eliminate the

Re: Query Set Problem

2010-09-04 Thread tresero
_price,buy_long,stop_sell,sell_short,stop_buy)"}, tables =['thesheet_dailystats'], where=['thesheet_dailystats.one_pair_id = csbuysell_csbuysell.one_pair_id AND thesheet_dailystats.the_date = csbuysell_csbuysell.the_date']) Notice this is also calling a stored procedure csbuysell_pl(...)

Query Set Problem

2010-09-03 Thread tresero
I want to convert this query: SELECT c.id, c.buy_long, c.stop_sell, c.sell_short, c.stop_buy, c.the_date, p.symbol, s.open_price, s.high_price, s.low_price, s.close_price FROM csbuysell c, onepair p, dailystats s WHERE