recovery

[Derek Atkins]

Quoting "Keith A. Milner" <kamilner at superlative.org>:

> On Thursday 01 November 2007 20:39:27 Tarlika Elisabeth Schmitz wrote:
>> On Thu, 01 Nov 2007 16:07:03 -0400
>>
>> Derek Atkins <warlord at MIT.EDU> wrote:
>> > Quoting Braindead <Braindead at diablops.com>:
>> > >> >>   SELECT * from Split where Split.amount_num/Split.amount_denom
>> > >> >> = 1/3;
>> >
>> > Okay.... Does this work in PG and MySQL?
>>
>> It works in PostgreSQL.
>> No idea about MySQL but I would assume so.
>
> I'm probably missing something obvious, but wouldn't you actually do:
>
> SELECT * from Split
> WHERE Split.amount_num = 1
> AND Split.amount_denom=3;

Nope, because that doesn't match the case where amount_num=10 and
amount_denom=30, but in the gnucash case we want 10/30 and 1/3 to
be considered equal.

> ???

> 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