recovery

[Derek Atkins]

Quoting Braindead <Braindead at diablops.com>:

> On Thu, 01 Nov 2007 10:34:45 -0400
> Derek Atkins <warlord at MIT.EDU> wrote:
>
>> hendrik at topoi.pooq.com writes:
>>
> <snip>
>> > In the XML, they set the unit for the account to 1/3.  Then they
>> > just represent it as 1.
>> > Or set the unit to 1/6.  Then represent it as 2.
>>
>> Umm.. I understand exactly how gnucash stores it, but you miseed my
>> point.  The person I was responding to was suggesting that numbers get
>> stored as decimal, and I was asking THAT person how you would suggest
>> that we store a decimal number that represents the number 1/3.  I know
>> very well how gnucash does it -- it stores TWO integers that represent
>> the rational number.  But moving that over to a SQL database might be
>> more problematic.  I'm not sure if you can do something like:
>>
>>   SELECT * from Split where Split.amount_num/Split.amount_denom = 1/3;
>>
>> Maybe you can?  I honestly don't know.
>
> You certainly can, at least we do things like that all the time in Firebird.
>
> Just thought I'd mention that ;-)

Okay... Can you do it in SQLite?

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available